on 11-19-2015 8:44 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.