| From: | Lynna Landstreet <lynna(at)spidersilk(dot)net> |
|---|---|
| To: | "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>, <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: Times and time zones |
| Date: | 2005-07-21 01:30:04 |
| Message-ID: | BF0472DC.1BA75%lynna@spidersilk.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
On 7/20/05 7:36 PM, Gavin M. Roy <gmr(at)ehpg(dot)net> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hui Chen | 2005-08-14 17:32:56 | Problem about connecting PostgreSQL through TCP/IP |
| Previous Message | Lynna Landstreet | 2005-07-21 01:12:31 | Re: Times and time zones |