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]
