MySQL中的DATEFDIFF函数 获取两个日期的时间间隔为1天:datediff(w1.recordDate,w2.recordDate)=1 select w1.id from Weather w1,Weather w2 where datediff(w1.recordDate,w2.recordDate)=1 and w1.Temperature > w2.Temperature;