//获取月份

SELECT * FROM BLOG WHERE MONTH(CREATETIME)=7;

//获取年份

SELECT * FROM BLOG WHERE YEAR(CREATETIME)=7;

//天数小时与获取年份月份相似.....

Logo

更多推荐