Convert of char to timestamp

[monaz]

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..

[Sainath.Srinivasan]

Did you search? There are loads of relating post.

Try to display the original value you wish to transform.

[monaz]

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..

Sorry i got the solution from our forum itself i used
"StringToTimestamp(TRIM(INPUTCOL):"000000","%yyyy%mm%dd%hh%nn%ss") "

Thanks