Andy Chan wrote: > > > Found out why. > > The date columns in the table is in fact TIMESTAMP instead of > DATE. Unfortunately, I was deceived by the output of sqlcli > - \dc and user_tab_columns. Only SQL studio correctly shows > that the type is TIMESTAMP. > > :x
Could it be that you used sometime ORACLE-mode where the kernel-known-datatype TIMESTAMP has to be shown as DATE, not meaning DATE in the INTERNAL-sqlmode-sense? Elke > > -----Original Message----- > From: Jean-Michel OLTRA [mailto:[EMAIL PROTECTED] > Sent: 2004?3?12? 20:39 > To: MaxDB digest (E-mail) > Subject: Re: Loader error (-25301) > > > Le vendredi 12 mars 2004, Andy Chan a �crit... > bonjour, > > > > date 'yyyy-mm-dd' > > wouldn't: > > DATE ISO > > be better ? > > -- > jm > > > -- > 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] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
