Archives of the TeradataForum

Message Posted: Mon, 28 Aug 2000 @ 16:20:14 GMT


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

Subj:		Re: MultiLoad Date Fields

From:		Barry Hull

Mary Lou,

Change the "FIELD" command in the "LAYOUT" section to define IJUNK02 as "CHAR(8)". The Multiload will then use the format that you specified to convert it to a date (as long as it's defined as a DATE column in the table). If you have trouble with it, you may have to put parenthesis around the entire expression like this:

(:IJUNK02 (format 'MMDDYYYY'))

Thanks,

Barry