TimeStamp Conversion
Posted: Wed Sep 19, 2007 9:17 am
I am facinig some problem with Conversion of string to timestamp
my input is Sequential file and i am loading(Append) data into existingOracle table.
Seq--->Trans----> Oracle Table
I am not able to view the date..
I am getting warning like :
Transformer_1,0: Conversion error calling conversion routine timestamp_from_string data may have been lost.
My input dates are like 19891025(YYYYMMDD,string format) and i want to load timestamp format in oracle table
i tried with the function StringToTimestamp(DSLink2.MBR_DOB_DT,"%yyyy-%mm-%dd %hh:%nn:%ss")
But i am not getting the timestamp..
Please give me idea what can i put in transformer
Thanks,
Reddy
my input is Sequential file and i am loading(Append) data into existingOracle table.
Seq--->Trans----> Oracle Table
I am not able to view the date..
I am getting warning like :
Transformer_1,0: Conversion error calling conversion routine timestamp_from_string data may have been lost.
My input dates are like 19891025(YYYYMMDD,string format) and i want to load timestamp format in oracle table
i tried with the function StringToTimestamp(DSLink2.MBR_DOB_DT,"%yyyy-%mm-%dd %hh:%nn:%ss")
But i am not getting the timestamp..
Please give me idea what can i put in transformer
Thanks,
Reddy