Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Apr 2002 @ 14:27:10 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Converting 4-digit dates to standard date
From:   John Balchunas

Successfully populated a new table converting 5 full dates thru an Insert/Select and CASE on each date. 52 million rows took just about three hours during the workday on an old 4-node 4700 without any apparent degradation of performance.

Thanks all for your help and to Mike Larkins for his class on optimizing CASE at Midwest TUG on April 23rd in Dayton.

John Balchunas
Jefferson County Public Schools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020