I am using this code for generating the timestamp in DataStage.The Target Table being TeraData. I used this in SQL Server and it worked fine. Even in TeraData it works fine expect the precision is all zero.
Code: Select all
Oconv(DATE(),"D-YMD[4,2,2]"):" ":Oconv(TIME(),"MTS") : ".":field(TIME(),".",2)
Code: Select all
2004-12-28 13:54:30.120
Code: Select all
2004-12-30 11:28:57.000000
Thanks
Mack