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

  • September 25, 2012 at 3:18 pm

    #1542101

    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?

    I originally wrote this for SQL 2000, so be my guest. 🙂 The code could be greatly simplified too, probably enough to convert it to inline code.

    I posted it mainly to give them an example of some code that I know I tested fairly completely.