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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq