Skip to content
  • There are no suggestions because the search field is empty.

T-SQL Script: Get Age calculation

T-SQL Script: Get Age calculation

SELECT DATEDIFF(YEAR, DateOfBirth, GETDATE())
     - CASE WHEN DATEADD(YEAR, DATEDIFF(YEAR, DateOfBirth, GETDATE()), DateOfBirth) > GETDATE() THEN 1 ELSE 0 END
FROM dbo.tblClientDetails;