Export (0) Print
Expand All

SqlMethods.DateDiffDay Method (Nullable(DateTimeOffset), Nullable(DateTimeOffset))

Counts the number of day boundaries between two nullable dates.

Namespace:  System.Data.Linq.SqlClient
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

static member DateDiffDay : 
        startDate:Nullable<DateTimeOffset> * 
        endDate:Nullable<DateTimeOffset> -> Nullable<int> 

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 a null reference (Nothing in Visual Basic), returns the number of day boundaries between the two specified dates. When one or both parameters are a null reference (Nothing in Visual Basic), returns a a null reference (Nothing in Visual Basic) 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.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5 SP1

.NET Framework Client Profile

Supported in: 4
Show:
© 2015 Microsoft