Convert of char to timestamp
Posted: Mon Apr 27, 2009 4:19 am
hi All,
My requirement is that we are extracting from the source whose data of feild process_date is type of datetime.
I have converted process_date to char(8) for my lookup purpose.
I have to load in Dataset file back to Timestamp datatype so i tried using StringToTimestamp in transformer stage for that feild.
but i am getting in output file for that feild process_date(*************)
Please suggest..
My requirement is that we are extracting from the source whose data of feild process_date is type of datetime.
I have converted process_date to char(8) for my lookup purpose.
I have to load in Dataset file back to Timestamp datatype so i tried using StringToTimestamp in transformer stage for that feild.
but i am getting in output file for that feild process_date(*************)
Please suggest..