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.