how to calculate age from given DOB in sql 2000
Database
2
Posts
2
Posters
0
Views
1
Watching
-
hi all i need to find members whose age is greater 75 yrs.how to calculate age from the give DOB. I used the following code.
DOB <= Dateadd(yy,-75,getdate())Plz help me to find out the correct way thanks in advancecheers sangeet
-
hi all i need to find members whose age is greater 75 yrs.how to calculate age from the give DOB. I used the following code.
DOB <= Dateadd(yy,-75,getdate())Plz help me to find out the correct way thanks in advancecheers sangeet
select * FROM WHERE datediff(year,convert(datetime,DATEOFBIRTH),getdate())>75 -- modified at 8:17 Wednesday 19th September, 2007