Age Calculator in SQL Server

Hi, Friends!

Today is a Special Day in my Life, "My Birthday".

Yeah!!! This is "20th August".

So, Today I calculate my age using Age Calculator in SQL Server.

USE tempdb

DECLARE @BIRTHDATE AS DATETIME = '1987-08-20 07:50:00.000'

DECLARE @TODATE AS DATETIME = '2015-08-20 00:00:00.000' --[You may use GETDATE()also]

SELECT DATEPART (YEAR,        @TODATE-@BIRTHDATE)-1900 AS [Years], 

       DATEPART (MONTH,       @TODATE-@BIRTHDATE)-1 AS [Months],  

       DATEPART (DAY,         @TODATE-@BIRTHDATE)-1 AS [Days],

       DATEPART (HOUR,        @TODATE-@BIRTHDATE) AS [Hours],

       DATEPART (MINUTE,      @TODATE-@BIRTHDATE) AS [Minutes],

       DATEPART (SECOND,      @TODATE-@BIRTHDATE) AS [Seconds],

       DATEPART (MILLISECOND, @TODATE-@BIRTHDATE) AS [Milliseconds]

Result:-

Years Months Days  Hours Minutes Seconds Milliseconds

28      0     0     16    10      0        0

WOW!!! Im just turn into 28 years Guy!!!...