Share via

SqlServerDbFunctionsExtensions.DateDiffMonth Method

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore
Assembly:
Microsoft.EntityFrameworkCore.SqlServer.dll
Package:
Microsoft.EntityFrameworkCore.SqlServer v8.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v2.1.11
Package:
Microsoft.EntityFrameworkCore.SqlServer v2.2.6
Package:
Microsoft.EntityFrameworkCore.SqlServer v3.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v3.1.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v5.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v6.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v7.0.0

Overloads

DateDiffMonth(DbFunctions, DateOnly, DateOnly)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).
DateDiffMonth(DbFunctions, DateTime, DateTime)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).
DateDiffMonth(DbFunctions, DateTimeOffset, DateTimeOffset)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).
DateDiffMonth(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).
DateDiffMonth(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).
DateDiffMonth(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).

DateDiffMonth(DbFunctions, DateOnly, DateOnly)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).

public static int DateDiffMonth (this Microsoft.EntityFrameworkCore.DbFunctions _, DateOnly startDate, DateOnly endDate);
static member DateDiffMonth : Microsoft.EntityFrameworkCore.DbFunctions * DateOnly * DateOnly -> int
<Extension()>
Public Function DateDiffMonth (_ As DbFunctions, startDate As DateOnly, endDate As DateOnly) As Integer

Parameters

_
DbFunctions

The DbFunctions instance.

startDate
DateOnly

Starting date for the calculation.

endDate
DateOnly

Ending date for the calculation.

Returns

Int32

Number of month boundaries crossed between the dates.

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to

DateDiffMonth(DbFunctions, DateTime, DateTime)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).

public static int DateDiffMonth (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTime startDate, DateTime endDate);
static member DateDiffMonth : Microsoft.EntityFrameworkCore.DbFunctions * DateTime * DateTime -> int
<Extension()>
Public Function DateDiffMonth (_ As DbFunctions, startDate As DateTime, endDate As DateTime) As Integer

Parameters

_
DbFunctions

The DbFunctions instance.

startDate
DateTime

Starting date for the calculation.

endDate
DateTime

Ending date for the calculation.

Returns

Int32

Number of month boundaries crossed between the dates.

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to

DateDiffMonth(DbFunctions, DateTimeOffset, DateTimeOffset)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).

public static int DateDiffMonth (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTimeOffset startDate, DateTimeOffset endDate);
static member DateDiffMonth : Microsoft.EntityFrameworkCore.DbFunctions * DateTimeOffset * DateTimeOffset -> int
<Extension()>
Public Function DateDiffMonth (_ As DbFunctions, startDate As DateTimeOffset, endDate As DateTimeOffset) As Integer

Parameters

_
DbFunctions

The DbFunctions instance.

startDate
DateTimeOffset

Starting date for the calculation.

endDate
DateTimeOffset

Ending date for the calculation.

Returns

Int32

Number of month boundaries crossed between the dates.

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to

DateDiffMonth(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).

public static int? DateDiffMonth (this Microsoft.EntityFrameworkCore.DbFunctions _, DateOnly? startDate, DateOnly? endDate);
static member DateDiffMonth : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<DateOnly> * Nullable<DateOnly> -> Nullable<int>
<Extension()>
Public Function DateDiffMonth (_ As DbFunctions, startDate As Nullable(Of DateOnly), endDate As Nullable(Of DateOnly)) As Nullable(Of Integer)

Parameters

_
DbFunctions

The DbFunctions instance.

startDate
Nullable<DateOnly>

Starting date for the calculation.

endDate
Nullable<DateOnly>

Ending date for the calculation.

Returns

Nullable<Int32>

Number of month boundaries crossed between the dates.

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to

DateDiffMonth(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).

public static int? DateDiffMonth (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTime? startDate, DateTime? endDate);
static member DateDiffMonth : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<DateTime> * Nullable<DateTime> -> Nullable<int>
<Extension()>
Public Function DateDiffMonth (_ As DbFunctions, startDate As Nullable(Of DateTime), endDate As Nullable(Of DateTime)) As Nullable(Of Integer)

Parameters

_
DbFunctions

The DbFunctions instance.

startDate
Nullable<DateTime>

Starting date for the calculation.

endDate
Nullable<DateTime>

Ending date for the calculation.

Returns

Nullable<Int32>

Number of month boundaries crossed between the dates.

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to

DateDiffMonth(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of month boundaries crossed between the startDate and endDate. Corresponds to SQL Server's DATEDIFF(month, @startDate, @endDate).

public static int? DateDiffMonth (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTimeOffset? startDate, DateTimeOffset? endDate);
static member DateDiffMonth : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<DateTimeOffset> * Nullable<DateTimeOffset> -> Nullable<int>
<Extension()>
Public Function DateDiffMonth (_ As DbFunctions, startDate As Nullable(Of DateTimeOffset), endDate As Nullable(Of DateTimeOffset)) As Nullable(Of Integer)

Parameters

_
DbFunctions

The DbFunctions instance.

startDate
Nullable<DateTimeOffset>

Starting date for the calculation.

endDate
Nullable<DateTimeOffset>

Ending date for the calculation.

Returns

Nullable<Int32>

Number of month boundaries crossed between the dates.

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to