DATEDIFF()函数返回两个日期之间的时间 DATEDIFF(datepart,startdate,enddate) -- 获取两个日期之间的天数SELECT DATEDIFF(day,'2021-01-01','2021-06-10'
DATEDIFF()函数返回两个日期之间的时间
DATEDIFF(datepart,startdate,enddate)
-- 获取两个日期之间的天数SELECT DATEDIFF(day,'2021-01-01','2021-06-10') AS days;SELECT DATEDIFF(day,'2021-01-01 08:00:00','2021-06-10 09:00:00') AS days;
-- 获取两个日期之间的月数SELECT DATEDIFF(month,'2021-01-01','2021-06-10') AS months;SELECT DATEDIFF(month,'2021-01-01 08:00:00','2021-06-10 09:00:00') AS months;
-- 获取两个日期之间的年数SELECT DATEDIFF(year,'2021-01-01','2022-06-10') AS years;SELECT DATEDIFF(year,'2021-01-01 08:00:00','2022-06-10 09:00:00') AS years;
-- startdate位置0表示1900-01-01,-1表示1899-12-31SELECT DATEDIFF(day, 0, '1900-01-01');-- 结果:0SELECT DATEDIFF(day, 0, '1900-01-31');-- 结果:30SELECT DATEDIFF(day, -1, '1900-01-01');-- 结果:1SELECT DATEDIFF(day, -1, '1900-01-31');-- 结果:31
来源地址:https://blog.csdn.net/shan1774965666/article/details/126359227
--结束END--
本文标题: SQL获取两个日期之间的天数
本文链接: https://www.lsjlt.com/news/395160.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-28
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0