Home Forums SQL Server 2005 T-SQL (SS2K5) Calculating age RE: Calculating age

  • September 20, 2013 at 3:36 pm

    #1652067

    This seems to work

    DECLARE @DOB DATETIME

    SET @DOB='9/19/2000'

    SELECT FLOOR(DATEDIFF(DD,@DOB,GETDATE())/365.25)