How to caculate Date of Age in ms sql server
- MS Sql Server
- 286
- October-03-2023
- by Junaid A
How to caculate Date of Age in ms sql server?
-- Step) 1
CREATE FUNCTION [dbo].[CalculateAge]
(
@DOB datetime , @calcDate datetime
)
RETURNS int
AS
BEGIN
declare @age int
IF (@calcDate < @DOB )
RETURN -1
-- If a DOB is supplied after the comparison date, then return -1
SELECT @age = YEAR(@calcDate) - YEAR(@DOB) +
CASE WHEN DATEADD(year,YEAR(@calcDate) - YEAR(@DOB)
,@DOB) > @calcDate THEN -1 ELSE 0 END
RETURN @age
END
go
-- Step) 2
go
SELECT dbo.CalculateAge('1985-09-15',Getdate()) as CurrentAge
