//获取月份
SELECT * FROM BLOG WHERE MONTH(CREATETIME)=7;
//获取年份
SELECT * FROM BLOG WHERE YEAR(CREATETIME)=7;
//天数小时与获取年份月份相似.....
//获取月份
SELECT * FROM BLOG WHERE MONTH(CREATETIME)=7;
//获取年份
SELECT * FROM BLOG WHERE YEAR(CREATETIME)=7;
//天数小时与获取年份月份相似.....