Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
"Andrew Bartley"
Date:
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 

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

From
Tom Lane
Date:
"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

Re: "Bad date external representation '2002-04-09

From
Thomas Lockhart
Date:
> 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