今天要做月份统计的比较,又学习到了一个函数,今天时间是2020-08-20号
select
DATEDIFF(YEAR,'2020-08-10 13:42:04.267',GETDATE())years,
DATEDIFF(MONTH,'2020-09-10 13:42:04.267',GETDATE())months,
DATEDIFF(day,'2020-08-9 13:42:04.267',GETDATE())days,
DATEDIFF(dd,'2020-08-9 13:42:04.267',GETDATE())dayss