Bug in date/time input format
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
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
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