Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 13:42:01 GMT

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

All,

I'm attempting to load a file into a Teradata table on V2.5 that contains an outputted date and time field from another system. The format of the fields are DDMMMYY and HH.MM.SS (e.g. "12MAY05 03.04.15", etc.).

My define is written as:

     ", START_SUBM (CHAR(16))",

and my insert is written as

     ", :START_SUBM (FORMAT'DDMMMYY HH.MM.SS',TIMESTAMP(0))",

however I'm getting a 6707 error on this field during the FastLoad execution. Every input record is being written to error table 1 and referencing this field as the bad field. Does anyone have any suggestions as to what I should change to correct this issue, or is it even possible to load a timestamp in this format?

Alternatively, I can (and have successfully) break the fields into a date field and a separate time field, but I'm having issues combining them to update into a timestamp field after the load completes. I'd consider using this second method as a viable option if I can't get the first option to work. Ultimately, I want to be able to calculate the interval between a submission and completion timestamp when I'm finished. Any suggestions would be greatly appreciated!

Thanks,

John

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