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
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,
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
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
* 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