Get an Accurate Age by Date [Tip/Trick]
Posted: 20 Feb 2010
Updated: 20 Feb 2010
Rating: 4.00/5
Votes: 2
Popularity: 1.20
Licence: The Code Project Open License (CPOL)
Bookmarked: 0
Downloaded: 0
DECLARE @Age intDECLARE @Date_of_birth datetimeDECLARE @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)