Can anyone help me with how to calculate the exact age.
Thanks in advance.
Printable View
Can anyone help me with how to calculate the exact age.
Thanks in advance.
Hi Jannat,
Try this code:
Hope that helps,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
Faris