ODBC Connector Timestamp issue

[pavankvk]

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

[pjedson]

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