Convert timestamp format

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

ray.wurlod · Post by **ray.wurlod** » Mon Jan 03, 2011 2:47 pm

Code: Select all

Left(InLink.TheLongTimestamp,23)

chulett · Post by **chulett** » Mon Jan 03, 2011 7:04 pm

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

muralidwhds · Post by **muralidwhds** » Tue Jan 04, 2011 3:31 am

How can i?

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

chulett · Post by **chulett** » Tue Jan 04, 2011 8:18 am

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