Home Forums SQL Server 2008 T-SQL (SS2K8) Age RE: Age

  • February 17, 2013 at 6:59 pm

    #1588703

    Jeff Moden (9/25/2012)

    Michael Valentine Jones (9/25/2012)

    You can use the function on the link below to find the age:

    Age Function F_AGE_IN_YEARS

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74462

    Any chance of making it NOT a scalar function?

    SELECT DATEDIFF(yy, 0, GETDATE() - DOB) Age_Way1,

    YEAR(GETDATE()-DOB) -1900 Age_Way2

    _____________
    Code for TallyGenerator