Thursday, May 7, 2009

How to write a query for selecting Today's Birthday Candidates using Sql Server?

select * from TableName where day(convert(datetime,'12/01/2009',101))=day(getdate()) and month(convert(datetime,'12/01/2009',101))=month(getdate());

No comments:

 
Feedback Form