time zone?
От | Tatsuo Ishii |
---|---|
Тема | time zone? |
Дата | |
Msg-id | 20031216.125642.112624833.t-ishii@sra.co.jp обсуждение исходный текст |
Ответы |
Re: time zone?
|
Список | pgsql-hackers |
Hi, it seems there is an inconsistency with time zone handling to me: test=# select version(); version -------------------------------------------------------------PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.95.3 (1 row) test=# set time zone 'JST'; ERROR: unrecognized time zone name: "JST" test=# set time zone 'Japan'; SET test=# select '2003-12-16 12:00:00 JST'::timestamp with time zone; timestamptz ------------------------2003-12-16 12:00:00+09 (1 row) test=# select '2003-12-16 12:00:00 Japan'::timestamp with time zone; ERROR: invalid input syntax for type timestamp with time zone: "2003-12-16 12:00:00 Japan" I know that this is because we need to use some OS's functionalities to handle day light saving time etc. But this kind of inconsistency makes users quite confusing. Any idea to improve this? -- Tatsuo Ishii
В списке pgsql-hackers по дате отправления: