Archives of the TeradataForum

Message Posted: Tue, 04 May 2004 @ 14:44:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Jackson:

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.

Michael Larkins
Certified Teradata Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>