Thread

1. Timestamp Error - 7.2

   Keith Gray <keith@heart.com.au> — 2002-09-25T01:06:52Z

   
   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
   
   
   
   
   

2. Re: Timestamp Error - 7.2

   Josh Berkus <josh@agliodbs.com> — 2002-09-25T16:13:21Z

   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