From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Question about timezones |
Date: | 2004-10-07 20:22:24 |
Message-ID: | 20041007202221.GE24742@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
The operating system I run (Linux) comes with many, many timezone files
for many different places in the world. For example:
$ TZ='Australia/Sydney' date
Fri Oct 8 06:15:31 EST 2004
$ TZ='Europe/Amsterdam' date
Thu Oct 7 22:15:38 CEST 2004
$ TZ='Africa/Bissau' date
Thu Oct 7 20:18:44 GMT 2004
$ TZ='America/Phoenix' date
Thu Oct 7 13:19:33 MST 2004
Is there any way I can use these from within postgresql? Those files
contains details about daylight saving changes and other useful details
like that, which a simple PST or EST won't cover. Or should I simply do
all my date/time conversion in my application?
Any ideas?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-10-07 20:33:26 | Re: PSQL undesired transaction behavior when connection is lost. |
Previous Message | Oliver Jowett | 2004-10-07 20:10:55 | Re: Problem with boolean type |