You are better off just changing your format to meet their's. I have struggled long and hard with their dates functionality (or lack thereof) and it isn't worth your time.
-----Original Message----- From: Andreas Goldstein [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 4:45 PM To: [email protected] Subject: TIMESTAMP/DATE Format & INSERT I am porting a database from Access to MaxDB. From the Access-DB I have made a SQL-Dump that contains about 800 dates with a date in it. The date-format in the dump-fil is "DD.MM.YYYY HH:MM:SS". I am now trying to insert these lines into the MaxDB-DB by using the SQL-Studio. For example the following codes demonstrates what I am trying to do: CREATE TABLE aaa ( id FIXED(10) DEFAULT SERIAL, sent TIMESTAMP, PRIMARY KEY (id)) // INSERT INTO aaa (sent) VALUES ('31.03.2005 13:35:21') ... Unfourtunately this does not work. I think that one point is a wrong date-format that should YYYY-MM-DD because of the ISO-mode. From the manual I do not understand, where I can change the ISO-mode to an other that meets my requirements. I would be happy if anyone can help me - thanks! -- Sparen beginnt mit GMX DSL: http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
