Page 1 of 1
date conversion
Posted: Sat Nov 19, 2005 11:25 am
by narayanavagu
I have a data in flat files containing only one column of type char(10) in the following format yyyy-mm-dd.
i want to transfor it into oracle thru odbc in the oracle specified date format (dd-mon-yy).
plz any body give the conversion code
Posted: Sat Nov 19, 2005 1:13 pm
by ray.wurlod
In the SDK routines there is a class of routines for converting to the expected date format for a number of different databases. You should be able to use one of these without reinventing the wheel. Open the routine and read the documentation (yes, they are documented!), to work out how to invoke them.
Use Conv Funs
Posted: Mon Nov 21, 2005 1:31 am
by dssiddu
hi
u have to use ICONV And OCONV functions.
Oconv(Iconv(Date Field,E)
By this u can get the req format.....
Check it out
Use Conv Funs
Posted: Mon Nov 21, 2005 1:31 am
by dssiddu
hi
u have to use ICONV And OCONV functions.
Oconv(Iconv(Date Field,E)
By this u can get the req format.....
Check it out
Re: date conversion
Posted: Mon Nov 21, 2005 5:21 am
by suresh.narasimha
narayanavagu wrote:I have a data in flat files containing only one column of type char(10) in the following format yyyy-mm-dd.
i want to transfor it into oracle thru odbc in the oracle specified date format (dd-mon-yy).
plz any body give the conversion code
Hi
Type D CODE in help ,You can get all the required date conversions
you can try this Oconv(Iconv(DateField,"D-YMD(4,2,2),"D-DMY[,A3,2]")
hi
Posted: Tue Nov 22, 2005 4:12 am
by jagadish25
hi vagu, u dont know about this.
i think all the oconv and iconv was explained bye kamal.
ok
how is our team
bye