SqlMethods.DateDiffDay Method

 

Counts the number of day boundaries between two specified dates.

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

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(DateTime, DateTime)

Counts the number of day boundaries between two non-nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(DateTimeOffset, DateTimeOffset)

Counts the number of day boundaries between two non-nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of day boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of day boundaries between two nullable dates.

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.

Return to top
Show: