Friday, 3 May 2013

Month / Year base search use Sql query

Month / Year base search use Sql query

SELECT * FROM TableName
   WHERE MONTH(<dataFiled>) = 2 AND YEAR(<dataFiled>) = 2013

Ex
SELECT * FROM  tblProcess
   WHERE MONTH(UserProcessDate) = 2 AND YEAR(UserProcessDate) = 2013

No comments:

Post a Comment