sql语句举例:
SELECT DATE_FORMAT(log_t.dtime,'%Y-%m') as cale,COUNT(*) FROM log_t
WHERE log_t.dtime BETWEEN DATE_SUB( CURRENT_DATE, INTERVAL 1 YEAR ) AND CURRENT_DATE GROUP BY grade
其中 dtime 为 Date类型的数据, DATE_SUB( CURRENT_DATE, INTERVAL 1 YEAR ) 计算当前日期之前一年的时间节点, CURRENT_DATE 为当前时间