Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 Jun 2000 @ 14:45:08 GMT

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

Subj:   Re: Loading Packed data to A Date column
From:   Simon Norris

If the data on input is stored as ' 7' and you want the data loaded to a numeric column it may be best to DEFINE the field as a CHAR(04) but load it to an integer column and let Teradata do the conversion.

There may be a need to put a FORMAT of 'ZZZ9' on the column in the VALUE clause. I'll check out some code at work today and let you know.

Simon Norris

  <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