I am new in DataStage designing. I have a problem with transforming the timestamp to date.
I am using transformer stage to change the timestamp to date
Code: Select all
TIMESTAMP.TO.DATE(DSLink4.CREATE_TIMESTAMP)
utput column = CREATE_DATE, type = date
When I ran this job, this is giving WARNING like
(Timestamp) transform error: Invalid timestamp input '2011-11-26 10:39:10.385000'
I am nothing getting in output table.
![Sad :(](./images/smilies/icon_sad.gif)
please help me to avoid this error