DateDiffDay Method

SqlMethods.DateDiffDay Method

Counts the number of day boundaries between two specified dates.

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

  NameDescription
Public method Static member DateDiffDay(DateTime, DateTime) Counts the number of day boundaries between two non-nullable dates.
Public method Static member DateDiffDay(Nullable<DateTime>, Nullable<DateTime>) Counts the number of day boundaries between two nullable dates.
Public method Static member DateDiffDay(DateTimeOffset, DateTimeOffset) Counts the number of day boundaries between two non-nullable dates.
Public method Static member DateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) Counts the number of day boundaries between two nullable dates.
Top

Corresponds to the SQL Server DATEDIFF function; using day to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF in the Microsoft SQL Server Books Online.

Community Additions

ADD
Show:
© 2016 Microsoft