Home Page for the TeradataForum
 

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016