Convert VARCHAR to Date
Posted: Tue Dec 26, 2006 3:44 am
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
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