This topic has not yet been rated - Rate this topic

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

Silverlight

Counts the number of hour boundaries between two nullable dates.

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

public static Nullable<int> DateDiffHour(
	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 hour boundaries between the two specified dates. When one or both parameters are null, returns a null value is returned.

Remarks

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

Version Information

Silverlight for Windows Phone

Supported in: Windows Phone OS 7.1

Platforms

For a list of the operating systems and browsers that are supported by Silverlight, see Supported Operating Systems and Browsers.

Reference

SqlMethods Class

DateDiffHour Overload

System.Data.Linq.SqlClient Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD