SqlServerDbFunctionsExtensions.DateDiffNanosecond Method

Reference

Definition

Namespace:: Microsoft.EntityFrameworkCore

Assembly:: Microsoft.EntityFrameworkCore.SqlServer.dll

Package:: Microsoft.EntityFrameworkCore.SqlServer v8.0.0

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

Package:: Microsoft.EntityFrameworkCore.SqlServer v2.1.11

Package:: Microsoft.EntityFrameworkCore.SqlServer v2.2.6

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Overloads

DateDiffNanosecond(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)	Counts the number of nanosecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTime, @endTime)`.
DateDiffNanosecond(DbFunctions, TimeSpan, TimeSpan)	Counts the number of nanosecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTimeSpan, @endTimeSpan)`.
DateDiffNanosecond(DbFunctions, TimeOnly, TimeOnly)	Counts the number of nanosecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTime, @endTime)`.
DateDiffNanosecond(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)	Counts the number of nanosecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTimeSpan, @endTimeSpan)`.
DateDiffNanosecond(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, DateOnly, DateOnly)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, DateTime, DateTime)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.

DateDiffNanosecond(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)

Counts the number of nanosecond boundaries crossed between the startTime and endTime. Corresponds to SQL Server's DATEDIFF(nanosecond, @startTime, @endTime).

public static int? DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, TimeOnly? startTime, TimeOnly? endTime);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<TimeOnly> * Nullable<TimeOnly> -> Nullable<int>

<Extension()>
Public Function DateDiffNanosecond (_ As DbFunctions, startTime As Nullable(Of TimeOnly), endTime As Nullable(Of TimeOnly)) As Nullable(Of Integer)

Parameters

_: DbFunctions

The DbFunctions instance.

startTime: Nullable<TimeOnly>

Starting time for the calculation.

endTime: Nullable<TimeOnly>

Ending time for the calculation.

Returns

Nullable<Int32>

Number of nanosecond boundaries crossed between the times.

Remarks

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

Applies to

DateDiffNanosecond(DbFunctions, TimeSpan, TimeSpan)

Counts the number of nanosecond boundaries crossed between the startTimeSpan and endTimeSpan. Corresponds to SQL Server's DATEDIFF(nanosecond, @startTimeSpan, @endTimeSpan).

public static int DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, TimeSpan startTimeSpan, TimeSpan endTimeSpan);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * TimeSpan * TimeSpan -> int

<Extension()>
Public Function DateDiffNanosecond (_ As DbFunctions, startTimeSpan As TimeSpan, endTimeSpan As TimeSpan) As Integer

Parameters

_: DbFunctions

The DbFunctions instance.

startTimeSpan: TimeSpan

Starting timespan for the calculation.

endTimeSpan: TimeSpan

Ending timespan for the calculation.

Returns

Int32

Number of nanosecond 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

DateDiffNanosecond(DbFunctions, TimeOnly, TimeOnly)

Counts the number of nanosecond boundaries crossed between the startTime and endTime. Corresponds to SQL Server's DATEDIFF(nanosecond, @startTime, @endTime).

public static int DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, TimeOnly startTime, TimeOnly endTime);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * TimeOnly * TimeOnly -> int

<Extension()>
Public Function DateDiffNanosecond (_ As DbFunctions, startTime As TimeOnly, endTime As TimeOnly) As Integer

Parameters

_: DbFunctions

The DbFunctions instance.

startTime: TimeOnly

Starting time for the calculation.

endTime: TimeOnly

Ending time for the calculation.

Returns

Int32

Number of nanosecond boundaries crossed between the times.

Remarks

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

Applies to

DateDiffNanosecond(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)

Counts the number of nanosecond boundaries crossed between the startTimeSpan and endTimeSpan. Corresponds to SQL Server's DATEDIFF(nanosecond, @startTimeSpan, @endTimeSpan).

public static int? DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, TimeSpan? startTimeSpan, TimeSpan? endTimeSpan);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<TimeSpan> * Nullable<TimeSpan> -> Nullable<int>

<Extension()>
Public Function DateDiffNanosecond (_ As DbFunctions, startTimeSpan As Nullable(Of TimeSpan), endTimeSpan As Nullable(Of TimeSpan)) As Nullable(Of Integer)

Parameters

_: DbFunctions

The DbFunctions instance.

startTimeSpan: Nullable<TimeSpan>

Starting timespan for the calculation.

endTimeSpan: Nullable<TimeSpan>

Ending timespan for the calculation.

Returns

Nullable<Int32>

Number of nanosecond 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

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

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

public static int? DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTimeOffset? startDate, DateTimeOffset? endDate);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<DateTimeOffset> * Nullable<DateTimeOffset> -> Nullable<int>

<Extension()>
Public Function DateDiffNanosecond (_ 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 nanosecond 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

DateDiffNanosecond(DbFunctions, DateTimeOffset, DateTimeOffset)

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

public static int DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTimeOffset startDate, DateTimeOffset endDate);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * DateTimeOffset * DateTimeOffset -> int

<Extension()>
Public Function DateDiffNanosecond (_ 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 nanosecond 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

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

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

public static int? DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, DateOnly? startDate, DateOnly? endDate);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<DateOnly> * Nullable<DateOnly> -> Nullable<int>

<Extension()>
Public Function DateDiffNanosecond (_ 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 nanosecond 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

DateDiffNanosecond(DbFunctions, DateOnly, DateOnly)

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

public static int DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, DateOnly startDate, DateOnly endDate);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * DateOnly * DateOnly -> int

<Extension()>
Public Function DateDiffNanosecond (_ 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 nanosecond 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

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

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

public static int? DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTime? startDate, DateTime? endDate);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * Nullable<DateTime> * Nullable<DateTime> -> Nullable<int>

<Extension()>
Public Function DateDiffNanosecond (_ 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 nanosecond 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

DateDiffNanosecond(DbFunctions, DateTime, DateTime)

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

public static int DateDiffNanosecond (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTime startDate, DateTime endDate);

static member DateDiffNanosecond : Microsoft.EntityFrameworkCore.DbFunctions * DateTime * DateTime -> int

<Extension()>
Public Function DateDiffNanosecond (_ 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 nanosecond 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

Share via

SqlServerDbFunctionsExtensions.DateDiffNanosecond Method

Definition

Overloads

DateDiffNanosecond(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)

Parameters

Returns

Remarks

Applies to

DateDiffNanosecond(DbFunctions, TimeSpan, TimeSpan)

Parameters

Returns

Remarks

Applies to

DateDiffNanosecond(DbFunctions, TimeOnly, TimeOnly)

Parameters

Returns

Remarks

Applies to

DateDiffNanosecond(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)

Parameters

Returns

Remarks

Applies to

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

Parameters

Returns

Remarks

Applies to

DateDiffNanosecond(DbFunctions, DateTimeOffset, DateTimeOffset)

Parameters

Returns

Remarks

Applies to

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

Parameters

Returns

Remarks

Applies to

DateDiffNanosecond(DbFunctions, DateOnly, DateOnly)

Parameters

Returns

Remarks

Applies to

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

Parameters

Returns

Remarks

Applies to

DateDiffNanosecond(DbFunctions, DateTime, DateTime)

Parameters

Returns

Remarks

Applies to

Additional resources