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
date conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Tue Nov 15, 2005 2:38 pm
- Contact:
date conversion
Venkata Narayana Vagu,
DW Developer
DW Developer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Use Conv Funs
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
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
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
u have to use ICONV And OCONV functions.
Oconv(Iconv(Date Field,E)
By this u can get the req format.....
Check it out
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
Re: date conversion
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]")
SURESH NARASIMHA
-
- Participant
- Posts: 4
- Joined: Mon Nov 14, 2005 1:48 pm
hi
hi vagu, u dont know about this.
i think all the oconv and iconv was explained bye kamal.
ok
how is our team
bye
i think all the oconv and iconv was explained bye kamal.
ok
how is our team
bye