SQL SERVER:获取两个日期之间的总天数

2021-12-13 00:00:00 sql date sql-server-2008 sql-server

我正在尝试获取两天之间的总天数:

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?

推荐答案

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

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.

相关文章