Home Forums SQL Server 2008 T-SQL (SS2K8) Best way to Calculate Human Age from a Birthdate RE: Best way to Calculate Human Age from a Birthdate

  • January 8, 2013 at 11:27 am

    #1574949

    DATEDIFF(YEAR,P.BIRTH_DATE,STPRD.STPR_START_DATE) - CASE WHEN MONTH(P.BIRTH_DATE)*100 + DAY(P.BIRTH_DATE) > MONTH(STPRD.STPR_START_DATE)*100 + DAY(STPRD.STPR_START_DATE) THEN 1 ELSE 0 END AS AGE,