Re: [GENERAL] Question about timezones

2004-10-17 Thread Martijn van Oosterhout
On Fri, Oct 08, 2004 at 09:52:00AM -0400, Tom Lane wrote: The infrastructure needed for this is finally present in 8.0, ie we have the timezone data available, but actually teaching AT TIME ZONE about it didn't get done in time. Likely it will appear in 8.1 (especially if you step up and do

Re: [GENERAL] Question about timezones

2004-10-08 Thread Martijn van Oosterhout
On Thu, Oct 07, 2004 at 01:43:49PM -0700, Steven Klassen wrote: * Martijn van Oosterhout [EMAIL PROTECTED] [2004-10-07 22:22:24 +0200]: 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,

Re: [GENERAL] Question about timezones

2004-10-08 Thread Tom Lane
Martijn van Oosterhout [EMAIL PROTECTED] writes: But it doesn't seem to work to actually work out times across the world w.r.t. daylight savings. ... For example, this script works out, given a time in one timezone, what it was in another timezone: What we need for that is the ability for AT

[GENERAL] Question about timezones

2004-10-07 Thread Martijn van Oosterhout
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

Re: [GENERAL] Question about timezones

2004-10-07 Thread Steven Klassen
* Martijn van Oosterhout [EMAIL PROTECTED] [2004-10-07 22:22:24 +0200]: 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