time zone?

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

Responses

Browse pgsql-hackers by date

  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