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;
- CASE WHEN DATEADD(YEAR, DATEDIFF(YEAR, DateOfBirth, GETDATE()), DateOfBirth) > GETDATE() THEN 1 ELSE 0 END
FROM dbo.tblClientDetails;