jain cj wrote:
> 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.
>
As far as I know, Oracle does not accept pure ('11-02-2003'),
because the format is like '11-FEB-2003'.
Otherwise TO_DATE('11-02-2003', 'DD-MM-YYYY') had to be given.
The TO_DATE-function is available in MaxDB's/SAP DB's Oracle-mode
(see SQLMODEs for a description).
With internal mode, it is not available.
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
