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

  • September 20, 2013 at 4:01 pm

    #1652073

    But they wouldn't be 1 until after their BDay

    or you could just

    DECLARE @DOB DATETIME

    SET @DOB='01/01/2013'

    SELECT FLOOR((DATEDIFF(DD,@DOB,'01/01/2014')+1)/365.25)