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..
Convert of char to timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Convert of char to timestamp
Sorry i got the solution from our forum itself i usedmonaz wrote: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..
"StringToTimestamp(TRIM(INPUTCOL):"000000","%yyyy%mm%dd%hh%nn%ss") "
Thanks