Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 May 2006 @ 13:54:46 GMT


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


Subj:   Re: Subtracting month from a date
 
From:   Victor Sokovin

  We discovered a problem that I thought others might be interested in.  


  The problem can occur when using INTERVAL to subtract a month from > a date where the previous month has fewer days than the current > month. If the current date is 2006-05-31 and then using INTERVAL > to subtract 1 month from the current date results in an illegal > date: 2006-04-31 (April has only 30 days).  


Thanks for the warning but this is not something new. Oracle would do exactly the same in this case. It's probably what ANSI specifications prescribe. Obviously, opinions can differ on this but at least we have some consistency across vendors.


Regards,

Victor



     
  <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