DATEDIFF(datepart, startdate, enddate)
Datepart Abbreviations
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
hour hh
minute mi, n
second ss, s
millisecond ms
SQLServer 中处理两个日期相减得到天数
最新推荐文章于 2023-04-04 15:30:53 发布