Select people older than 65

HI all,

I think this solution may resolve the problem

declare @people table (name varchar(20),[birth date] datetime)
insert @people values ('A','20/10/1900')
insert @people values ('B','20/10/1940')
insert @people values ('C','20/10/1960')
insert @people values ('D','20/10/1970')
insert @people values ('F','20/10/2013')

select *,datediff(day,[birth date],getdate()) diff 
from @people where datediff(day,[birth date],getdate())/365 > 65

Best regards.