Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 Jun 2000 @ 14:48:22 GMT

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

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

Hasn't anyone heard of Y2K? Why are dates still being output without the century?

If you want a julian date of format YYDDD loaded correctly you need to 'window' the date.

You have two options;

1) Add an INMOD to the FastLoad to 'window' the date (FastLoad scripts cannot contain the CASE statement)

2) Convert the FastLoad script to MultiLoad and use the CASE statement to 'window' the date.

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: 28 Jun 2020