如何获取两个日期之间的天数 [英] How to get number of days in between two dates
本文介绍了如何获取两个日期之间的天数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的,
如何获取天数< span class =code-keyword> in 两个日期之间
低于SQL中的查询。
选择 DATEDIFF(DAY,' 2016-03-11 12:00',' 2016-03-13 20:00')
它的权利,但我想用十进制格式。
谢谢
Basit
我的尝试:
亲爱的,
如何 天数在两个日期之间的
低于SQL中的查询。
选择 DATEDIFF (DAY,' 2016-03-11 12:00',' 2016-03-13 20:00')
它的权利,但我想以十进制格式。
谢谢
Basit
解决方案
您可以将日期转换为浮动并减去那些:
DECLARE @ d1 DATETIME = ' 2016-03-11 12:00'
DECLARE @ d2 DATETIME = ' 2016-03-13 20:00'
< span class =code-keyword> SELECT CAST( @ d2 AS FLOAT 跨度>) - CAST( @ d1 AS FLOAT )
- 返回:2.33333333333576
Dear,
How to get number of days in between two dates
below query in SQL.
select DATEDIFF(DAY,'2016-03-11 12:00','2016-03-13 20:00')
its right but i want in decimal format.
Thanks
Basit
What I have tried:
Dear,
How to get number of days in between two dates
below query in SQL.
select DATEDIFF(DAY,'2016-03-11 12:00','2016-03-13 20:00')
its right but i want in decimal format.
Thanks
Basit
解决方案
You can convert the dates to floats and substract those:
DECLARE @d1 DATETIME = '2016-03-11 12:00' DECLARE @d2 DATETIME = '2016-03-13 20:00' SELECT CAST(@d2 AS FLOAT) - CAST(@d1 AS FLOAT) -- Returns: 2.33333333333576
这篇关于如何获取两个日期之间的天数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文