Timestamp transform error

atul9806 · Post by **atul9806** » 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

pandeesh · Post by **pandeesh** » Tue Mar 06, 2012 6:44 am

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

atul9806 · Post by **atul9806** » 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

chulett · Post by **chulett** » 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.