DSXchange

I am selecting a field that is a timestamp from a SQL Server database, where ever the milliseconds start with 0 DataStage is dropping the 0's, for example, my timestamp in my source DB is 2005-04-09 08:32:48.050 but when I select in datastage it is returning 2005-04-09 08:32:48.500. I have tired to ...

Thanks Ray - I am using a Dynamic RDBMS stage to connect to the SQL Server. These millisecond permutations occur in view data, and also in a text file.

I am selecting a field that is a timestamp from a SQL Server database, where ever the milliseconds start with 0 DataStage is dropping the 0's, for example, my timestamp in my source DB is 2005-04-09 08:32:48.050 but when I select in datastage it is returning 2005-04-09 08:32:48.500. I have tired to ...