how to calculate age

[jannat]

Can anyone help me with how to calculate the exact age.

Thanks in advance.

[Faris]

Hi Jannat,

Try this code:

DECLARE @DOB AS DATETIME
DECLARE @NOW AS DATETIME

SET @DOB = '19820426 15:35:10'
SET @NOW = GETDATE()

SELECT 
	@DOB AS DOB,
	@NOW AS NOW,
	DATEDIFF(yy,@DOB,@NOW) AS YRS,
	DATEDIFF(m,@DOB,@NOW) - (DATEDIFF(yy,@DOB,@NOW) * 12) AS MONTHS,
	DATEDIFF(d,@DOB,@NOW) - (DATEDIFF(yy,@DOB,@NOW) * 365) AS DAYS,
	DATEDIFF(hh,@DOB,@NOW) - (DATEDIFF(d,@DOB,@NOW) * 24) AS HOURS,
	DATEDIFF(mi,@DOB,@NOW) - (DATEDIFF(hh,@DOB,@NOW) * 60) AS MINS,
	DATEDIFF(s,@DOB,@NOW) - (DATEDIFF(mi,@DOB,@NOW) * 60) AS SECS

Hope that helps,

Faris