Tatsuo Ishii wrote:
> > Also, JST doesn't work anymore, but JST9 does. JST has no daylight
> > savings time values, so it is a valid timezone setting, while EST is
> > not:
> >
> > test=> set timezone = 'JST';
> > ERROR: unrecognized time zone name: "JST"
> >
> > test=> set timezone
> Also, JST doesn't work anymore, but JST9 does. JST has no daylight
> savings time values, so it is a valid timezone setting, while EST is
> not:
>
> test=> set timezone = 'JST';
> ERROR: unrecognized time zone name: "JST"
>
> test=> set timezone = 'JST9';
> SET
Note t
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > Shall I add JST to our zic database?
>
> No. We have to update that from the upstream database every release;
> maintaining our own private mods is not acceptable. If you want JST
> to be recognized as a zic timezone, go lobby the upstream maintaine
Bruce Momjian writes:
> I assume it is related to these two TODO entries:
> o Merge hardwired timezone names with the TZ database; allow either
> kind everywhere a TZ name is currently taken
Yes, the point here is that the datetime token table has a bunch of
hardwired zone name
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Shall I add JST to our zic database?
No. We have to update that from the upstream database every release;
maintaining our own private mods is not acceptable. If you want JST
to be recognized as a zic timezone, go lobby the upstream maintainers
for it.
Tatsuo Ishii wrote:
> > > Also, JST doesn't work anymore, but JST9 does.
> >
> > JST9 is valid per the POSIX rules. JST isn't listed as a zone name in
> > the zic database, so it's not valid. (Try "Japan" instead.)
>
> Shall I add JST to our zic database? It's quite confusing that
> "2005-10-14
> > Also, JST doesn't work anymore, but JST9 does.
>
> JST9 is valid per the POSIX rules. JST isn't listed as a zone name in
> the zic database, so it's not valid. (Try "Japan" instead.)
Shall I add JST to our zic database? It's quite confusing that
"2005-10-14 12:00 JST" is allowed while ""SET
Bruce Momjian writes:
> I am playing with our allowed timezone settings and saw a few strange
> things. It understands "EST5EDT", but how does it understand "XYT5ABT"?
Because the code in src/timezone does what the POSIX standard says it
must do. The relevant man page on my HPUX box says
I am playing with our allowed timezone settings and saw a few strange
things. It understands "EST5EDT", but how does it understand "XYT5ABT"?
test=> set timezone = 'XYT5ABT';
SET
test=> SELECT current_timestamp;
now
---
