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 convert and cast the data in my select statement but nothing seems to work. Needless to say I am new to DataStage and would appreciate any suggestions.

Welcome aboard! :D

Are you using an ODBC stage to connect to SQL Server?
Is it in View Data that these strange permutations of milliseconds are occurring?
What happens if you create a job that selects from SQL Server and writes to a text file? What goes into the text file?

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.