Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2000 @ 11:35:18 GMT


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

Subj:		TIMESTAMP and Multiloads

From:		Howard Bradley

I have recently started to play with the TIMESTAMP data type on Teradata and am developing a Multiload which populates a Timestamp column on a table . In the past when loading DATE data types , if the format of the date on the input file was different to the format of the destination column in the table I have simply specified the input format within the Multiload and Teradata handles it accordingly . E.g date on input file is '13-10-2000' and column format is 'YYYYMMDD' then the multiload values section contains something like

:DATE_COLUMN (DATE,FORMAT 'DD-MM-YYYY') .

Does anything similar exist for TIMESTAMP data types as the input file format I need to load is

'YYYY-MM-DD-HH.MM.SS.SSSSSS' but the format of the column expects 'YYYY-MM-DD HH:MM:SS.SSSSSS' and the only way I have managed to get it to work is to define the layout of the input file in individual blocks of Date , Hours , Minutes and seconds and then concatenate them all in the values section in the format that is expected which is a bit messy .I don't know if this makes a difference but we are an MVS site on V2R3

Thanks.

Howard .


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

Attachments

Library

Quick Reference