cancel
Showing results for 
Search instead for 
Did you mean: 

convert a string TO_DATE()

daniela_boamba
Explorer
0 Kudos

Hello,

I need to import data from an oracle database but the fonction TO_DATE don't exist on MAXDB.

Can someone help me?

Insert into "currency"()

   values (to_date('01-DEC-98','DD-MON-RR'),'Canadien Dollar')

Thank you very much.

Daniela

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Daniela,

please check the SQLMode which you are using during the import into MaxDB.

I expect that you are doing the import with SQLMODE Internal which is the MaxDB syntax.

If you switch to the SQLMode ORACLE ( which is a partly oracle compatible mode)  todate is available in this mode.

You set this SQLMODe during connect. See MaxDB docuemntation for more details about the SQLMODE.

Regards, Christiane

daniela_boamba
Explorer
0 Kudos

Thank you Christiane,

I will test this.

Best regards,

Daniela

Answers (0)