Using a sql query how to calculate age from DOB

Question

for displayin records of persons whose age is greater than 18.

select *from table where ( (CURDATE()-dob) > 18)

is it correct...?

ll it work..?

Answer 1

Rengas solution is very good, so I don't want to second guess ... however your additional details say you want it in a single query.

select * from table where addyears(dob, 18) > curdate()

Answer 2

build a user-defined function (UDF) in SQL Server and call it from the Stored Procedure

Create FUNCTION dbo.GetAge (@DOB datetime, @Today Datetime) RETURNS Int

AS

Begin

Declare @Age As Int

Set @Age = Year(@Today) - Year(@DOB)

If Month(@Today) < Month(@DOB)

Set @Age = @Age -1

If Month(@Today) = Month(@DOB) and Day(@Today) < Day(@DOB)

Set @Age = @Age - 1

Return @AGE

End

SELECT *

FROM Table

WHERE  dbo.GetAge(e.Date_Of_Birth, getdate()) >= 18