DSXchange

Hi

We are using ODBC Connector against SQL Server database. Have many jobs specified as Timestamp 23,3 to read sql server datetime fields.

However datastage is ignoring the milli seconds

2016-10-01 23:59:59.997

its ignoring .997

using microsecond it adds more digits(6) after the decimal

How exactly can we read the 3 digits after decimal using timestamp 23,3

Try Using custom format string:
"%yyyy-%mm-%dd %hh:%mm:%ss.3"
Good luck !!