View Single Post

   
  #8 (permalink)  
Old 02-29-2008, 05:44 AM
tony_petruzzi@sheriff.org
 
Posts: n/a
Default Re: Need help with MS SQL query

select *
from table
where datediff(day, getdate(), dateadd(year, (year(getdate()) -
year(birthday)), birthday)) < 30

Reply With Quote