On 7/20/05 7:36 PM, Gavin M. Roy <gmr@xxxxxxxx> wrote: > Why not just tell PostgreSQL the timezone for the user and use > timestamp with timezone and let pgsql do the rest? I believe it's > SET TIMEZONE '-8'; for PST/PDT, etc. That command works for an entire session, correct? Unfortunately, this is a travel-related site, so sometimes there are going to be arrival and departure times in different time zones, so I don't think that would work in this case. But it's likely to be useful in other applications, so thank you for the info. Lynna -- Spider Silk Design - http://www.spidersilk.net 509 St Clair W Box 73576, Toronto ON Canada M6C 1C0 Tel 416.651.2899 - Toll Free 1.866.651.2899 - Cell 416.873.9289
