1. 查询10年6月到9月的信息 SELECT * FROM table WHERE YEAR(dateField)=2010 and MONTH(dateField)>=6 and MONTH(dateField)<=9 转载于:https://www.cnblogs.com/Kakasi/archive/2011/09/15/2177216.html