数据库按年月日查询
-
有日期字段,字段类型为datatime,利用这个字段可以分别根据年、月、日来获取相关数据。
-
函数
- month()
- year()
- day()
- week()
-
条件
- group by
- order by
- desc
- 其他常用…
-
实例
-
根据年
SELECT count(*),DATE_FORMAT(createtime,'%Y') as time FROM hits GROUP BY time; or select sum(未清金额),year(CreateTime) '年' from Home_Comment_t group by year(CreateTime)
-
根据月
SELECT count(*
-