Archives of the TeradataForum
Message Posted: Tue, 10 Oct 2000 @ 11:35:18 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|