csworkman

mysql - DATEDIFF 函数

2020-11-27 Mr Chang 数据库

DATEDIFF是两个日期的天数差集

举例：编写一个 SQL 查询，来查找与之前（昨天的）日期相比温度更高的所有日期的 id 。

select a.Id from Weather as a join Weather as b on a.Temperature > b.Temperature and dateDiff(a.RecordDate,b.RecordDate) = 1 

评论(0) 浏览(883)