status of yet another timezone todo item

Started by Joachim Wielandover 19 years ago2 messages
#1Joachim Wieland
joe@mcknight.de

Hi,

what do people think about this TODO item:

o Merge hardwired timezone names with the TZ database; allow either
kind everywhere a TZ name is currently taken

I think it is kind of done. The hardwired timezone names are no longer
hardwired and the "America/New_York" syntax is valid in timestamps and
times as well.

Joachim

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joachim Wieland (#1)
Re: status of yet another timezone todo item

Joachim Wieland <joe@mcknight.de> writes:

what do people think about this TODO item:
o Merge hardwired timezone names with the TZ database; allow either
kind everywhere a TZ name is currently taken
I think it is kind of done.

Not quite --- SET TIMEZONE doesn't take the abbreviations.

I'm not sure how important it is to accept SET TIME ZONE 'AKST'
given that such a thing is not going to have any DST awareness;
for most parts of the world, it's probably *wrong* to do this
rather than SET TIME ZONE 'America/Anchorage'.
But that was part of the original thought behind the TODO item.
Do we want to explicitly decide not to support that?

I'm not sure whether there are any other holes (I thought of
AT TIME ZONE, but it seems to work with both).

regards, tom lane