Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Aug 2000 @ 20:37:55 GMT


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


Subj:   Re: MultiLoad Date Fields
 
From:   Fred Pluebell

Datatype of IJUNK02 is CHAR; FORMAT clause given is only valid for DATE, hence the 3617 error.

If the input data matches the FORMAT used in CREATE TABLE, the datatype conversion from CHAR to DATE can be done implicitly. If you want to override the format, you must also specify explicit type conversion:

:IJUNK02 (DATE,FORMAT'YYYYMMDD')

or

CAST(:IJUNK02 AS DATE FORMAT'YYYYMMDD')



     
  <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