SQL SERVER：获取两个日期之间的总日期 [英] SQL SERVER: Get total days between two dates

问题描述

我试图得到两天之间的总天数：

I'm trying to get the total number of days between two days:

1/1/2011
3/1/2011

RETURN
62

是可能在SQL Server中执行？

Is it possible to do in SQL Server?

推荐答案

打印DATEDIFF（DAY，'1/1/2011 '，'3/1/2011'）会给你你以后的东西。

PRINT DATEDIFF(DAY, '1/1/2011', '3/1/2011') will give you what you're after.

这给出了午夜界限的次数在两个日期之间交叉。如果您将这两个日期包含在计数中，则可能需要添加一个，或者如果您不想包含任何一个日期，则可以减去一个。

This gives the number of times the midnight boundary is crossed between the two dates. You may decide to need to add one to this if you're including both dates in the count - or subtract one if you don't want to include either date.

这篇关于SQL SERVER：获取两个日期之间的总日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！