Postgres Pro
Downloads
Home   >   mailing lists

Thread: Timestamp Error - 7.2

Timestamp Error - 7.2

From
Keith Gray
Date:

We have moved from 7.1 to 7.2 and get the following error when
extracting dates.

Bad timestamp external representation ' '


eg. INSERT INTO mytable VALUES('1', '2001-09-24')

Seems to accept dd/mm/yyyy

(What about ISO default?)
-- 

Keith Gray
Technical Services Manager
Heart Consulting Services

Re: Timestamp Error - 7.2

From
"Josh Berkus"
Date:
Keith,

> We have moved from 7.1 to 7.2 and get the following error when
> extracting dates.
> 
> Bad timestamp external representation ' '
> 
> 
> eg. INSERT INTO mytable VALUES('1', '2001-09-24')

The error, as you have described it, is highly unlikely.   You will
need to provide more information if you still want help. Please:

1. Post table defintions.
2. Post your *actual* SQL statements which trigger the error, not
example ones which you have nto actually tested.

-Josh Berkus