From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | time zone? |
Date: | 2003-12-16 03:56:42 |
Message-ID: | 20031216.125642.112624833.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2003-12-16 03:59:11 | pg_service.conf ignores dbname parameter |
Previous Message | Bruce Momjian | 2003-12-16 01:23:41 | Re: fork/exec patch |