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 d

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

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 lik

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

[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 2