SqlServerDbFunctionsExtensions.DateDiffDay SqlServerDbFunctionsExtensions.DateDiffDay SqlServerDbFunctionsExtensions.DateDiffDay Method

Definition

Overloads

DateDiffDay(DbFunctions, DateTime, DateTime) DateDiffDay(DbFunctions, DateTime, DateTime) DateDiffDay(DbFunctions, DateTime, DateTime)

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

DateDiffDay(DbFunctions, DateTimeOffset, DateTimeOffset) DateDiffDay(DbFunctions, DateTimeOffset, DateTimeOffset) DateDiffDay(DbFunctions, DateTimeOffset, DateTimeOffset)

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

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

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

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

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

DateDiffDay(DbFunctions, DateTime, DateTime) DateDiffDay(DbFunctions, DateTime, DateTime) DateDiffDay(DbFunctions, DateTime, DateTime)

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

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

Parameters

_
DbFunctions DbFunctions DbFunctions

The DbFunctions instance.

startDate
DateTime DateTime DateTime

Starting date for the calculation.

endDate
DateTime DateTime DateTime

Ending date for the calculation.

Returns

Number of day boundaries crossed between the dates.

DateDiffDay(DbFunctions, DateTimeOffset, DateTimeOffset) DateDiffDay(DbFunctions, DateTimeOffset, DateTimeOffset) DateDiffDay(DbFunctions, DateTimeOffset, DateTimeOffset)

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

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

Parameters

_
DbFunctions DbFunctions DbFunctions

The DbFunctions instance.

startDate
DateTimeOffset DateTimeOffset DateTimeOffset

Starting date for the calculation.

endDate
DateTimeOffset DateTimeOffset DateTimeOffset

Ending date for the calculation.

Returns

Number of day boundaries crossed between the dates.

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

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

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

Parameters

_
DbFunctions DbFunctions DbFunctions

The DbFunctions instance.

startDate
Nullable<DateTime>

Starting date for the calculation.

endDate
Nullable<DateTime>

Ending date for the calculation.

Returns

Number of day boundaries crossed between the dates.

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

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

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

Parameters

_
DbFunctions DbFunctions DbFunctions

The DbFunctions instance.

startDate
Nullable<DateTimeOffset>

Starting date for the calculation.

endDate
Nullable<DateTimeOffset>

Ending date for the calculation.

Returns

Number of day boundaries crossed between the dates.

Applies to