Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 04 May 2004 @ 17:05:33 GMT

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

Subj:   Re: Multiload Problem With Date Columns - V2R5.1
From:   Dieter Noeth

PriceJ wrote:

  Sorry - our layout actually is CHAR(10) with incoming values in the form mm/dd/yyyy.  

You probably specified mm/dd/yyyy as your default format in V2R4.1 in DBS Control Record - General Field 21. Default Date Format

but in V2R5 this Field is obsolete (Reserved for future use).

Setting 15. DateForm to ANSIDate doesn't help, because ANSI always expects date in yyyy-mm-dd.

Specify date columns as CHAR(10) instead of DATE and Cast it to a Date. This will use the column's default format.


  <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: 15 Jun 2023