RE: TIMESTAMP/DATE Format & INSERT

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:accountistnurzumleerengedacht@xxxxxx]
Sent: Thursday, March 31, 2005 4:45 PM
To: maxdb@xxxxxxxxxxxxxxx
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/maxdb?unsub=kevin.wilson@xxxxxxxxxxx

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx