"Bad date external representation '2002-04-09 00:02:60.00+10'".

Started by Andrew Bartleyalmost 24 years ago3 messagesgeneral
Jump to latest
#1Andrew Bartley
abartley@evolvosystems.com

Hi,

We are using Postgres 7.1.3.

We keep getting these

"Bad date external representation '2002-04-09 00:02:60.00+10'". Not just in the one table. It seems random.

All the reading I have done over the past few days does not really give me a clear Idea on what this is.

It really is starting to become a problem with me having to manually update these time stamps.

Can any one give me a clear explanation of what it is and how I can prevent it.

Thanks

Andrew

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andrew Bartley (#1)
Re: "Bad date external representation '2002-04-09 00:02:60.00+10'".

"Andrew Bartley" <abartley@evolvosystems.com> writes:

We are using Postgres 7.1.3.

We keep getting these

"Bad date external representation '2002-04-09 00:02:60.00+10'". Not just i=
n the one table. It seems random.

Update to 7.2.

regards, tom lane

#3Thomas Lockhart
lockhart@fourpalms.org
In reply to: Andrew Bartley (#1)
Re: "Bad date external representation '2002-04-09

We are using Postgres 7.1.3.
We keep getting these
"Bad date external representation '2002-04-09 00:02:60.00+10'". Not
just in the one table. It seems random.

What system are you running on?

- Thomas