date format

sir,

  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.