Allowed timezone values
От | Bruce Momjian |
---|---|
Тема | Allowed timezone values |
Дата | |
Msg-id | 200510131657.j9DGv5v10503@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: Allowed timezone values
Re: Allowed timezone values |
Список | pgsql-hackers |
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------------------------------ 2005-10-13 12:48:39.59164-04(1 row) test=> SELECT current_timestamp + '3 months'; ?column?------------------------------- 2006-01-13 12:48:32.765068-05(1row) (Shouldn't current_timestamp's label be "current_timestamp", and not "now"?) 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 -- 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, Pennsylvania19073
В списке pgsql-hackers по дате отправления: