SQL server 版本
计算时间差:
select DATEDIFF(DAY,'2022-02-01','2022-03-01')
--换成参数
select DATEDIFF(DAY,w1.recordDate,w2.recordDate)
MYSQL版本
select datediff(w1.recordDate,w2.recordDate)
如果报错:Incorrect parameter count in the call to native function ‘datediff’
那就是看:https://www.cda.cn/discuss/post/details/600132341703710c9ef662c8