Re: [SQL] Timestamp Error - 7.2

2002-09-25 Thread Josh Berkus
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 informatio

[SQL] Timestamp Error - 7.2

2002-09-24 Thread Keith Gray
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/ (What about ISO default?) -- Keith Gray Technical Services Manager Heart Consulting Servi