Find Age

Question

Dear sir How to find Age in stored procedure using sql server give example with coding.

Kunal Naik · Answer

Hi try this DECLARE @ dateOfBirth DATETIME SET @ dateOfBirth = '10/13/1990' DECLARE @ age INT SET @ age = FLOOR ( DATEDIFF ( DAY  @ dateOfBirth  GETDATE ()) / 365 ) DECLARE @ month INT SET @ month = DATEPART ( MM  @ dateOfBirth ) SELECT @ age as Age  @ month as [ Month ]

Krishna Garad · Answer

Check this Select DateDiff(yearDOBColumnGetDate())as Age From TblName