Timestamps

curtcopp · Post by **curtcopp** » Mon Apr 25, 2005 2:59 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 25, 2005 8:35 pm

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?

curtcopp · Post by **curtcopp** » Tue Apr 26, 2005 11:49 am

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.