Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 31 Dec 2003 @ 17:02:35 GMT

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

Subj:   Re: ADD_MONTHS
From:   Grenwelge, Bill A.

Nope, it is working as designed. Add_Months does exactly that deals only with the month. If your date is 2003-11-30 and you subtract one from 11 you get 10. It doesn't actually figure out what the days are, just subtracts the appropriate number or adds the appropriate number to the month.

Bill Grenwelge
Data Warehouse
Union Planters Bank

  <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