Export (0) Print
Expand All

SqlMethods.DateDiffDay Method (Nullable(Of DateTimeOffset), Nullable(Of 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)

Public Shared Function DateDiffDay ( _
	startDate As Nullable(Of DateTimeOffset), _
	endDate As Nullable(Of DateTimeOffset) _
) As Nullable(Of Integer)


Type: System.Nullable(Of DateTimeOffset)

The start date for the time period.

Type: System.Nullable(Of DateTimeOffset)

The end date for the time period.

Return Value

Type: System.Nullable(Of Int32)
When both parameters are not Nothing, returns the number of day boundaries between the two specified dates. When one or both parameters are Nothing, returns a Nothing 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
© 2015 Microsoft