Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 04 May 2004 @ 14:44:51 GMT


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


Subj:   Re: Multiload Problem With Date Columns - V2R5.1
 
From:   Michael Larkins

Jackson:

Your format needs to match your data. The format you are specifying is char(10) with the slashes and the format you indicate for your data is char(8) without the slashes. So, your (format 'mmddyyyy') is what should appear on your INSERT command in the load utility.


Hope this helps.

Michael Larkins
Certified Teradata Master



     
  <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