Millisecond Permutations
Posted: Mon May 09, 2005 12:56 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. I am using a Dynamic RDBMS stage to connect to the SQL Server. These millisecond permutations occur in view data, and also if sent to a text file. Needless to say I am new to DataStage and would appreciate any suggestions.
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. I am using a Dynamic RDBMS stage to connect to the SQL Server. These millisecond permutations occur in view data, and also if sent to a text file. Needless to say I am new to DataStage and would appreciate any suggestions.