Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 19:57:47 GMT


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


Subj:   Re: Select 1 day of the current month
 
From:   Geoffrey Rommel

  Plus, there is always: date/100+1  



Ouch! This expression assumes too much about the internal representation of dates. Don't make any assumptions about internal representations!! (What if, in the next release, dates were stored as the number of days since 1/1/1?)



     
  <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