Home Forums SQL Server 7,2000 T-SQL How can we calculate Age of employee? RE: How can we calculate Age of employee?

  • These are links to my original post of the function from the prior post on this thread, plus another that you might find useful.

    Computing the age of someone is more difficult than it might seem when you take into account different month lengths, leap year, and other things.

    This function returns age in format YYYY MM DD.

    Age Function F_AGE_YYYY_MM_DD:

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

    This function returns age in years.

    Age Function F_AGE_IN_YEARS:

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