Know your age in SQL Server 2008

Just put your Date of Birth (DOB) at parameter @FRMDT and  execute following code...

DECLARE @FRMDT AS DATETIME

DECLARE @TODT AS DATETIME

SET @FRMDT = '1987-08-20'

SET @TODT = GETDATE()

SELECT DATEPART (YEAR, @TODT-@FRMDT)-1900 AS YEARS,  

DATEPART (MONTH, @TODT-@FRMDT)-1 AS MONTHS,    

DATEPART (DAY, @TODT-@FRMDT)-1 AS DAYS,  

DATEPART (HOUR, @TODT-@FRMDT) AS HOURS,

DATEPART (MINUTE, @TODT-@FRMDT) AS MINUTES,

DATEPART (SECOND, @TODT-@FRMDT) AS SECONDS,

DATEPART (MILLISECOND, @TODT-@FRMDT) AS MILLISECONDS