DSXchange

Posted: **Mon Jan 03, 2011 9:59 am**

Hi,

can anybody suggest me how to convert the Timestamp from db2 database to SQL server Db in Datastage server Edition.

YYYY-MM-DD HH:MI:SS.ssssss To YYYY-MM-DD HH:MI:SS.sss

Posted: **Mon Jan 03, 2011 2:47 pm**

Code: Select all

Left(InLink.TheLongTimestamp,23)

Posted: **Mon Jan 03, 2011 7:04 pm**

In other words, just chop off the last three "s" bits.

Posted: **Tue Jan 04, 2011 3:31 am**

How can i?

chulett wrote:In other words, just chop off the last three "s" bits.

Posted: **Tue Jan 04, 2011 8:18 am**

How? With the syntax Ray posted, hence the 'in other words' comment.

DSXchange

Convert timestamp format

Convert timestamp format