一、年度查询
查询 本年度的数据SELECT *
FROMblog_articleWHERE year( FROM_UNIXTIME( BlogCreateTime ) ) = year( curdate( ))
二、查询季度数据
查询数据附带季度数SELECTArticleId, quarter( FROM_UNIXTIME( `BlogCreateTime` ) )FROM`blog_article`
其他的同前面部分:查询 本季度的数据SELECT *
FROMblog_articleWHERE quarter( FROM_UNIXTIME( BlogCreateTime ) ) =quarter( curdate( ))
三、查询月度数据
本月统计(MySQL)select * from booking where month(booking_time) =
month(curdate()) and year(booking_time) = year(curdate())
本周统计(MySQL)select * from spf_booking where month(booking_time) =
month(curdate()) and week(booking_time) =week(curdate())
四、时间段
N天内记录WHERE TO_DAYS(NOW()) - TO_DAYS(时间字段) <=N
当天的记录where date(时间字段)=date(now())
或where to_days(时间字段) =to_days(now());
查询一周:select * from table where DATE_SUB(CURDATE(), INTERVAL