how to calculate age

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

Thanks in advance.

Hi Jannat,

Try this code:

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