sql,取得当前系统时间,算时间区间 mysql: SELECT * from (SELECT H_TEMPERATURE FROM WENSHIDU WHERE TH_TIME >=date_sub(NOW(), interval 1 hour) AND TH_TIME<= NOW() order by TH_TIME desc ) as data limit 0,1; 来自为知笔记(Wiz)