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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
