Home Forums SQL Server 2005 T-SQL (SS2K5) Calculating age RE: Calculating age
gilbert delarosa
SSC-Addicted
Points: 425
More actions
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)