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/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
