DATEDIFF() 函数返回两个日期之间的时间。
DATEDIFF(datepart,startdate,enddate)
例
SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate
当查询日期差为1的销量id时,可以用
select *
from 日销 as a cross join 日销 as b
on datediff(a.日期,b.日期)=1;
给定一个 Weather 表,编写一个 SQL 查询,来查找与之前(昨天的)日期相比温度更高的所有日期的 Id。
select w1.Id as Id
from Weather as w1
join Weather as w2
where datediff(w1.RecordDate,w2.RecordDate)=1
and w1.Temperature>w2.Temperature;
上述代码中,需要注意的是DateDiff函数在Mysql中,是括号前一个减去后一个