SQL Server CESQL Server 2014SQL Server 2000SQL Server 2012SQL Server 2008R2SQL Server 2008SQL Server 2005SQL Server
Get accurate age by date






4.80/5 (3 votes)
Get accurate age by date using MS SQL Server
DECLARE @Age int
DECLARE @Date_of_birth datetime
DECLARE @Today varchar(11)
SELECT @Date_of_birth = '03/05/1979'
SELECT @Today = GETDATE()
SELECT @Age = FLOOR(DATEDIFF(day, @Date_of_birth, @Today) / 365.25)
PRINT 'Your age is: ' + CONVERT(varchar, @Age)