DSXchange

Posted: **Tue Mar 06, 2012 6:36 am**

Hi All
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)

Input column = CREATE_TIMESTAMP, type = 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.

please help me to avoid this error

Posted: **Tue Mar 06, 2012 6:44 am**

can you try setting the extended property as milliseconds for the timestamp field?

Posted: **Tue Mar 06, 2012 7:20 am**

Sorry I didn't get you, where I have to change these settings
I already set this as timestamp(26,6)

Thx

Posted: **Tue Mar 06, 2012 7:32 am**

I don't recall Server jobs supporting milliseconds in timestamps. Just treat the field as a string and substring off the date or use Field() to get it.

DSXchange

Timestamp transform error

Timestamp transform error