sql server datediff()函数 [英] Sql server datediff() function
问题描述
嗨伙计....
我有两个SQL DateDiff()查询如下..
SELECT DATEDIFF(MONTH,'07 / 01/2017','08 / 10/2017')
SELECT DATEDIFF(月,'08 / 10 / 2017','2017/01/07')
有谁能帮帮我,我需要使用哪一个?
在此先感谢..
我尝试过:
我很困惑'08 / 10/2017','07/01/2017'关于我需要使用哪个开始日期和结束日期的日期。
Hi Folks....
I have two SQL DateDiff() Queries like below..
SELECT DATEDIFF(MONTH,'07/01/2017','08/10/2017')
SELECT DATEDIFF(MONTH,'08/10/2017','07/01/2017')
Can anyone please help me which one i need to use?
Thanks in Advance..
What I have tried:
I am confused about '08/10/2017','07/01/2017' dates about which one i need to use start date and end date.
推荐答案
阅读文档: SQL Server DATEDIFF()函数 [ ^ ]
如文档中所示,函数签名是
As shown in the documentation, the function signature is
DATEDIFF(datepart,startdate,enddate)
然后使用
then use
SELECT DATEDIFF(MONTH,'07/01/2017','08/10/2017')
如果你需要一个正数作为返回值。
if you need a positive number as return value.
这篇关于sql server datediff()函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!