select t1.id,
DATE_FORMAT(DATE_ADD(bj_time,INTERVAL aging/24-1 day),'%Y-%m-%d') as bj_time,
t1.T_MAX,t1.T_MIN,t1.RH_AVG_D,t1.WS_AVG_D,t1.RAIN_24H
from t_naf t1
INNER JOIN t_msis t2 on t1.ID = t2.ID and t2.TYPE = 1
where t1.bj_time = (select max(bj_time) from t1) and aging%24=0
and DATE_ADD(bj_time,INTERVAL aging/24 day) >= #{time01}
and DATE_ADD(bj_datetime,INTERVAL aging/24 day) <= #{time02}
order by t1.id, aging
DATE_FORMAT(a01,a02),用来转日期格式,a01代表被转的日期,a02代表日期格式。
DATE_ADD(b01,INTERVAL b02 day),用来对日期进行计算,b01代表被计算的日期,b02代表需要的计算的天数,我这里是以day举例,day也可以换成hour、WEEK 、等…
%Y与%y的区别:比如2019年,%Y会显示2019,%y就会显示19