Archives of the TeradataForum
Message Posted: Tue, 04 May 2004 @ 14:44:51 GMT
Your format needs to match your data. The format you are specifying is char(10) with the slashes and the format you indicate for your data is char(8) without the slashes. So, your (format 'mmddyyyy') is what should appear on your INSERT command in the load utility.
Hope this helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|