Martijn van Oosterhout <kleptog@svana.org> 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 TIME ZONE to specify a
DST-aware zone name. Right now it can only take DST-ignorant zone
names. So you can do
('2004-12-01 12:0:0' AT TIME ZONE 'AESST') AT TIME ZONE 'MEWT'
but not
('2004-12-01 12:0:0' AT TIME ZONE 'Australia/Sydney') AT TIME ZONE 'Europe/Amsterdam'
which of course is what you want.
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 the work ;-)).
regards, tom lane