Question about timezones

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.

Responses

Browse pgsql-general by date

  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