We have started our migration from oracle database to sap db..and we are using the same code and table structure.
problem is like this
eg:
existing code in oracle is -- Insert into tablename values('11-02-2003') . date getting from the gui is 'dd-mm-yyyy' format and it cannot change from the front end.
when i tried the same code in sap db it throwing error..when i given '2003-02-11' it is working.
so how to convert(to_date) the 'dd-mm-yyyy' fdormat to sap db format? is there any to_date function is sap dab?
please give an immediate reply.
Jain Jose.C
_________________________________________________________________
ICICI's NRI services. They make life easy. http://server1.msn.co.in/msnspecials/nriservices/index.asp Find out more.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
