Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 16:42:03 GMT


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


Subj:   Re: Substract 1 year from leap year - bug?
 
From:   Hassinger, Bill

Just my 2 cents. Since not getting the actual last day of the month is problematic either using ADD_Months (6/30/2004, -1) which goes to 5/30, not 5/31 or '2004-03-31' - Interval '1' which returns an error, we have come up with two solutions:

1) Go to the first day of the month following the month you want the last day for and subtract 1. ADD_Months((date '2004-05-24' - Extract(day from '2004-05-24')) + 1, -5) -1. The -5 would point to whatever month follows the desired month.

2) Change the syscalendar so the every calendar date has the beginning of the month, end of the month, and end of previous month as columns in the view.



     
  <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