Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DateDiffSecond Method (Nullable(DateTimeOffset), Nullable(DateTimeOffset))

SqlMethods.DateDiffSecond Method (Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of second boundaries between two nullable dates.

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

public static Nullable<int> DateDiffSecond(
	Nullable<DateTimeOffset> startDate,
	Nullable<DateTimeOffset> endDate


Type: System.Nullable<DateTimeOffset>

The start date for the time period.

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 second 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 second 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