Hai,
I'm trying to convert VARCHAR(40) data from an Oracle DB source on windows to date data format for an oracle output table.
My Source Column is (Start Date -(mm/dd/yyyy) )
Datatype : Varchar
Target Datatype is (Agg_Start Date) -(dd-mon-yyyy))
Datatype: Date.
I have tried this format : OConv(IConv(Dslink.Start_Date, "D"),"D-YMD[4,2,2]"):" 00:00:00"
And also I have tried this query also
Oconv(Iconv(Dslink.Start_Date, "D MDY[A,2,4]"),"D-YMD[4,2,2]")
When i run the job, i got this warning.
stgSURVEY_EXTERNAL_JOURNAL_REVENUE..Transformer: At row 1, link "LNK_ _PERIPHERAL_SURVEY", while processing column "START_DT"
Value treated as NULL
Attempt to convert String value "2006-12-31" to Date type unsuccessful.
What function/transform should I use?
Regards,
amit
Convert VARCHAR to Date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Fri Jul 28, 2006 2:11 pm
Convert VARCHAR to Date
Sunshine
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This question looks suspiciously like this recent thread - are you on the same project?
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.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA