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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
