 |
 |
Archives of the TeradataForum
Message Posted: Tue, 21 Mar 2006 @ 14:38:17 GMT
| Subj: | | Re: Casting Time stamp in Mload |
| |
| From: | | Victor Sokovin |
| | We are having Data in flat file structure extracted thru COBOL program & timestamp using systemtime in unix that is YYYYMMDDHHMMSSMS,
now we want to load the same in Teradata database as timestamp. Please advice how to cast the said field in MLoad script. | |
I think the problem is in the final CAST. It relies on the session defaults. The default in the SQLA session is probably in line with the
data, and everything works. But the ML session might have different defaults. In general, it is probably not a good idea to rely on session
defaults. Try to CAST to TIMESTAMP(0)using the explicit FORMAT, in the similar way as you CAST to DATE in the above SQL.
Regards,
Victor
| |
