Bug in date/time input format

From: Christopher Swan <chris(at)exile(dot)co(dot)nz>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Bug in date/time input format
Date: 2002-10-07 22:58:16
Message-ID: B9C878D8.7B77%chris@exile.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi, I have detected a bug in the date / time input format used in an insert
statement in Postgres 7.2.1-5 (Redhat 7.3).

If I use the following format:

'Tue, 08 Oct 2002 10:01:02 +1300'

then I get the following error:

ERROR: Bad timestamp external representation 'Tue, 08 Oct 2002 10:01:02
+1300'

However if I use this format:

'Tue, 08 Oct 2002 10:01:02 NZDT'

it inserts ok.

'+1300' is valid for New Zealand during the daylight saving period.

Regards, Christopher Swan

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pierre 2002-10-08 15:33:26 Re: Problem compiling postgresql 7.3b2
Previous Message Peter Eisentraut 2002-10-07 19:23:51 Re: Problem compiling postgresql 7.3b2