SELECT <if test="dateType == 1"> //日 DATE_FORMAT(s.create_time,'%Y%m%d') days, </if> <if test="dateType == 2">//周 DATE_FORMAT(s.create_time,'%Y%u') days, </if> <if test="dateType == 3">//月 DATE_FORMAT(s.create_time,'%Y%m') days, </if> SUM(s.lx1_use_time) useTime,s.did,UNIX_TIMESTAMP(s.create_time) as createTime FROM sp_air_water_state_history s
sql 根据日,周,月统计数据
最新推荐文章于 2023-06-09 14:01:36 发布