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?

推荐答案

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.

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