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());
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment