DateDiffMonth Method

SqlMethods.DateDiffMonth Method

 

Counts the number of month boundaries between two specified dates.

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

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of month boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of month boundaries between two nullable dates.

Corresponds to the SQL Server DATEDIFF function; using month 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:
© 2016 Microsoft