OCI date problem. Pls guide.
Posted: Wed Jul 23, 2003 3:12 am
After searching thru the site, I saw a lot of query regarding this, but could not find a suitable answer. I do not have the PDF documentation to refer to, as sugested by some members. Here is my problem.. (DS 5.2)
My input is OCI8 stage and the column is CHAR(26) field having a value of say, 1998-08-01-14.15.02.178759. My target is a OCI8 stage and the column is a DATE field. I an trying different methods to put the value but nothing seems to work.
I have written a function using Oconv and Iconv to get the date as 1/8/1998 or 01-AUG-1998, but in vain. I tried the built-in transform DateTimeStampToOraOCI(Arg) but that too does not work.
My DATE column is shown as Timestamp in the Data Stage. Even if I make it 'Date' in DS, it does not work.
Any suggestions ? Thanks a lot in advance.
D Paul
My input is OCI8 stage and the column is CHAR(26) field having a value of say, 1998-08-01-14.15.02.178759. My target is a OCI8 stage and the column is a DATE field. I an trying different methods to put the value but nothing seems to work.
I have written a function using Oconv and Iconv to get the date as 1/8/1998 or 01-AUG-1998, but in vain. I tried the built-in transform DateTimeStampToOraOCI(Arg) but that too does not work.
My DATE column is shown as Timestamp in the Data Stage. Even if I make it 'Date' in DS, it does not work.
Any suggestions ? Thanks a lot in advance.
D Paul