Ok, ignore this previous post :) ALTER TABLE had been used to add a couple fields to
the old set1 table and the order of fields was no longer
the same. The error returned was due to datatype mismatch on the fields in the table
:)
Specifying the exact fields in the INSERT and SELECT corrects my mistake.
Stephen
On Tue, 09 Mar 2004 17:16:19 , [EMAIL PROTECTED] sent:
>
>Using MaxDB 7.5.0.8 on Windows 2000 the following fails:
>
>INSERT INTO tempset1 SELECT * FROM set1 WHERE timestampfield > '2004-02-28 23:30:00'
>
>Where the statement:
>
>SELECT * FROM set1 WHERE timestampfield > '2004-02-28 23:30:00'
>
>Works fine in the same context. Error returned:
>
>[MySQL MaxDB][SQLOD32 DLL][MaxDB] Invalid datetime format;-3050 POS(1) Invalid
>timestamp format:ISO
>
>Not sure if I'm running into a MaxDB problem or my own code. I also tried {ts
>'2004-02-28 23:30:00' } format and it fails. Anyone confirm?
>
> Stephen Gutknecht
> full time traveler...
> Currently in Phoenix, Arizona USA heading to Dallas, Texas soon!
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
