AW: TIMESTAMP/DATE Format & INSERT

Andreas Goldstein wrote:
> 
> 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!
> 

the kernel is able to handle different date-time-formats. But
unfortunately ODBC (and SQLStudio uses it) defines its own
date-time-format looking like ISO.
Therefore the kernel has to use ISO if ODBC/SQLStudio is talking to him
--> causing the mentioned trouble for users wanting to use a different
format.

Elke
SAP Labs Berlin


> --
> 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=elke.zabach@xxxxxxx


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