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