Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 20:57:29 GMT

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

Subj:   Re: Select 1 day of the current month
From:   David Hough

  >> 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?)  

I agree with Geoffrey: don't treat the date as an integer with div and mod. Use one of the extract or sys_calendar solutions. And test your chosen solution because there have been a number of wrong answers supplied to the list:


should read




should read


/dave hough

  <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