//Assuming the table name as Users and fieldname as Bdate
select * from Users
where month(Bdate)=month(getdate())
and day(Bdate)between Day(getdate())
and day(dateadd(day,30,getdate()))
To check whether the user’s b’day is in the current month or not using stored prcedure
August 1, 2009 at 10:10 am (sqlserver-2005)
Tags: asp.net, birthday, find date in current month, stored procedure
