Hi Elke, You're right. I default my sqlcli session to ORACLE mode. I've tried that with INTERNAL mode, and can see it is TIMESTAMPS.
Thanks for your advise. Cheers, Andy -----Original Message----- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: 2004?3?15? 17:17 To: Andy Chan; MaxDB digest (E-mail) Subject: RE: Loader error (-25301) 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 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
