Search found 1 match
- Tue Aug 08, 2006 4:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Timestamp conversion in SQL Server
- Replies: 4
- Views: 1525
Timestamp conversion in SQL Server
we are using Parallel, Windows, Sql server 2005 we are getting like this in Flat files 7/6/2004 5:00:00 AM 8/15/2005 4:59:00 AM 11/21/2005 4:22:22 AM Target is sql server using datatype TIMESTAMP. need to be converting into 2004-07-06 05:00:00.000 2005-08-15 04:59:00:000 2005-11-21 04:22:22:000 if a...