Tag Archives: SQL Server calculate age

SQL Script to Calculate Age from Date Of Birth

Last week, I got a assignment to calculate age from the date of birth. It was pretty simple, I used the following TSQL script find out the age precisely up to minutes.   declare @birth_day datetime set @birth_day = '19790510 07:10:00' --- Date of birth for which, you wanted to calculate age in years, months, [...]