SqlMethods.DateDiffDay Method (Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)
[ This article is for Windows Phone 8 developers. If you’re developing for Windows 10, see the latest documentation. ]
Counts the number of day boundaries between two nullable dates.
Assembly: System.Data.Linq (in System.Data.Linq.dll)
public static Nullable<int> DateDiffDay( Nullable<DateTimeOffset> startDate, Nullable<DateTimeOffset> endDate )
Parameters
- startDate
- Type: System.Nullable<DateTimeOffset>
The start date for the time period.
- endDate
- Type: System.Nullable<DateTimeOffset>
The end date for the time period.
Return Value
Type: System.Nullable<Int32>When both parameters are not null, returns the number of day boundaries between the two specified dates. When one or both parameters are null, returns a null value.
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.
Show: