date conversion

[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

[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.

[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

[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

[suresh.narasimha]

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]")

[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