Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 22 Feb 2010 @ 21:44:37 GMT

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

Subj:   Re: Age calculation
From:   Anomy Anom

<-- Anonymously Posted: Monday, February 22, 2010 16:01 -->

Per V2R6.2 DR96278 (see Tech Alert NTA1553): the TD12.0 behavior is correct.

According to ANSI SQL standard, units smaller than the unit of the result are to be ignored in the calculation. So, when computing difference in years for two date values, the month and day values in each of the two operands should be ignored.

  <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