mysql 月度账单汇总_MySQL按年度、季度、月度、周、日SQL统计查询

说明SELECT YEAR('2014-10-29') //2014

SELECT MONTH('2014-10-29') //10

SELECT DAY('2014-10-29') //29

SELECT QUARTER('2014-10-29') //4 季度

SELECT DAYOFWEEK('2014-10-29') //4 星期

一、年度查询

查询本年度的数据SELECT *

FROM blog_article

WHERE year( FROM_UNIXTIME( BlogCreateTime ) ) = year( curdate( ))

二、查询季度数据

查询数据附带季度数SELECT ArticleId, quarter( FROM_UNIXTIME( `BlogCreateTime` ) )

FROM `blog_article`

其他的同前面部分：查询本季度的数据SELECT *

FROM blog_article

WHERE 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 w