sql按月进行查询

 

1.sql按月进行查询

select   *   from   yourtable   where   year(yourdatefield)='2009'   and   month(yourdatefield)='5'

 

2.sql按两个月份之间查询

SELECT *
FROM infos
WHERE (YEAR(pubdate) = '2009') AND (MONTH(pubdate) BETWEEN '6' AND '7')
ORDER BY pubdate DESC

 

3.sql按两个年月份查询

SELECT *
FROM infos
WHERE (YEAR(pubdate) BETWEEN '2009' AND '2011') AND (MONTH(pubdate) BETWEEN
      '6' AND '8')
ORDER BY pubdate DESC