Thread: Bug in date/time input format

Bug in date/time input format

From
Christopher Swan
Date:
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

Re: Bug in date/time input format

From
Peter Eisentraut
Date:
Christopher Swan writes:

> 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:

Is there a spot in the documentation that leads you to believe that this
format is supported?  If not, then it's not a bug.

--
Peter Eisentraut   peter_e@gmx.net

Re: Bug in date/time input format

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.net> writes:
> Christopher Swan writes:
>> If I use the following format:
>> 'Tue, 08 Oct 2002 10:01:02 +1300'
>> then I get the following error:

> Is there a spot in the documentation that leads you to believe that this
> format is supported?  If not, then it's not a bug.

It is a bug, because +1300 *should* be accepted.  The fact that you
can't get more than 180 degrees of longitude away from Greenwich has
not deterred the politicians who set timezone rules :-(.  I don't know
of any -1300 time zone, but +1300 is used in the real world.

            regards, tom lane