Edit

SqlMethods.DateDiffNanosecond Method

  • Reference

Definition

Namespace:
System.Data.Linq.SqlClient
Assembly:
System.Data.Linq.dll

Counts the number of nanosecond boundaries between two specified dates.

Overloads

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

Counts the number of nanosecond boundaries between two nullable dates.
DateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of nanosecond boundaries between two nullable dates.
DateDiffNanosecond(DateTime, DateTime)

Counts the number of nanosecond boundaries between two non-nullable dates.
DateDiffNanosecond(DateTimeOffset, DateTimeOffset)

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

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

Counts the number of nanosecond boundaries between two nullable dates.

public:
 static Nullable<int> DateDiffNanosecond(Nullable<DateTimeOffset> startDate, Nullable<DateTimeOffset> endDate);
public static int? DateDiffNanosecond (DateTimeOffset? startDate, DateTimeOffset? endDate);
static member DateDiffNanosecond : Nullable<DateTimeOffset> * Nullable<DateTimeOffset> -> Nullable<int>
Public Shared Function DateDiffNanosecond (startDate As Nullable(Of DateTimeOffset), endDate As Nullable(Of DateTimeOffset)) As Nullable(Of Integer)

Parameters

startDate
Nullable<DateTimeOffset>

The start date for the time period.

endDate
Nullable<DateTimeOffset>

The end date for the time period.

Returns

Nullable<Int32>

When both parameters are not null, returns the number of nanosecond boundaries between the two specified dates. When one or both parameters are null, returns a null value.

Remarks

Corresponds to the SQL Server DATEDIFF function using nanosecond to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF.

Applies to

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

Counts the number of nanosecond boundaries between two nullable dates.

public:
 static Nullable<int> DateDiffNanosecond(Nullable<DateTime> startDate, Nullable<DateTime> endDate);
public static int? DateDiffNanosecond (DateTime? startDate, DateTime? endDate);
static member DateDiffNanosecond : Nullable<DateTime> * Nullable<DateTime> -> Nullable<int>
Public Shared Function DateDiffNanosecond (startDate As Nullable(Of DateTime), endDate As Nullable(Of DateTime)) As Nullable(Of Integer)

Parameters

startDate
Nullable<DateTime>

The start date for the time period.

endDate
Nullable<DateTime>

The end date for the time period.

Returns

Nullable<Int32>

When both parameters are not null, returns the number of nanosecond boundaries between the two specified dates. When one or both parameters are null, returns a null value.

Remarks

Corresponds to the SQL Server DATEDIFF function using nanosecond to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF.

Applies to

DateDiffNanosecond(DateTime, DateTime)

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

public:
 static int DateDiffNanosecond(DateTime startDate, DateTime endDate);
public static int DateDiffNanosecond (DateTime startDate, DateTime endDate);
static member DateDiffNanosecond : DateTime * DateTime -> int
Public Shared Function DateDiffNanosecond (startDate As DateTime, endDate As DateTime) As Integer

Parameters

startDate
DateTime

The start date for the time period.

endDate
DateTime

The end date for the time period.

Returns

Int32

The number of nanosecond boundaries between the two specified dates.

Remarks

Corresponds to the SQL Server DATEDIFF function using nanosecond to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF.

Applies to

DateDiffNanosecond(DateTimeOffset, DateTimeOffset)

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

public:
 static int DateDiffNanosecond(DateTimeOffset startDate, DateTimeOffset endDate);
public static int DateDiffNanosecond (DateTimeOffset startDate, DateTimeOffset endDate);
static member DateDiffNanosecond : DateTimeOffset * DateTimeOffset -> int
Public Shared Function DateDiffNanosecond (startDate As DateTimeOffset, endDate As DateTimeOffset) As Integer

Parameters

startDate
DateTimeOffset

The start date for the time period.

endDate
DateTimeOffset

The end date for the time period.

Returns

Int32

The number of nanosecond boundaries between the two specified dates.

Remarks

Corresponds to the SQL Server DATEDIFF function using nanosecond to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF.

Applies to