Re: Allowed timezone values

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 = 'JST9';
> > SET
>
> Note that JST and JST9 are completely different timezone. I'm not
> sure this is correct or not...
>
> test=# select '2005-10-14 18:00' at time zone 'JST';
> timezone
> ---------------------
> 2005-10-15 08:00:00
> (1 row)
>
> test=# select '2005-10-14 18:00' at time zone 'JST9';
> timezone
> ---------------------
> 2005-10-14 14:00:00
> (1 row)

Oops, yea. It should be JST-9:

test=> select '2005-10-14 18:00' at time zone 'JST-9';
timezone
---------------------
2005-10-15 07:00:00
(1 row)

test=> select '2005-10-14 18:00' at time zone 'JST';
timezone
---------------------
2005-10-15 07:00:00
(1 row)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073