u011097323的专栏

在计算同比环比时需要用到本日、本月1日、上月本日、上月1日，年初 及去年对应的时间select CURDATE() as cur_day,DATE_FORMAT(CURDATE(),'%Y-%m-01') as cur_month_first_day,DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1 DAY) as cur_year_first_day,DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 1 MONT.

按起止时间查询where 1=1<if test="startTime!=null"> AND DATE_FORMAT(a.data_time, "%Y-%m-%d") &gt;= DATE_FORMAT(#{startTime},"%Y-%m-%d")</if><if test="endTime!=null"> AND DATE_FORMAT(a.data_time, "%Y-%m-%d") &lt;= DATE_FO...