SqlMethods.DateDiffMillisecond Method

Definition

Namespace:

System.Data.Linq.SqlClient

Assembly:

System.Data.Linq.dll

Counts the number of millisecond boundaries between two specified dates.

Overloads

DateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of millisecond boundaries between two nullable dates.
DateDiffMillisecond(DateTime, DateTime)	Counts the number of millisecond boundaries between two non-nullable dates.
DateDiffMillisecond(DateTimeOffset, DateTimeOffset)	Counts the number of millisecond boundaries between two non-nullable dates.
DateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>)	Counts the number of millisecond boundaries between two nullable dates.

Remarks

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

DateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of millisecond boundaries between two nullable dates.

public:
 static Nullable<int> DateDiffMillisecond(Nullable<DateTimeOffset> startDate, Nullable<DateTimeOffset> endDate);

public static int? DateDiffMillisecond (DateTimeOffset? startDate, DateTimeOffset? endDate);

static member DateDiffMillisecond : Nullable<DateTimeOffset> * Nullable<DateTimeOffset> -> Nullable<int>

Public Shared Function DateDiffMillisecond (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 millisecond 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 millisecond to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF.

DateDiffMillisecond(DateTime, DateTime)

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

public:
 static int DateDiffMillisecond(DateTime startDate, DateTime endDate);

public static int DateDiffMillisecond (DateTime startDate, DateTime endDate);

static member DateDiffMillisecond : DateTime * DateTime -> int

Public Shared Function DateDiffMillisecond (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 millisecond boundaries between the two specified dates.

Remarks

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

DateDiffMillisecond(DateTimeOffset, DateTimeOffset)

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

public:
 static int DateDiffMillisecond(DateTimeOffset startDate, DateTimeOffset endDate);

public static int DateDiffMillisecond (DateTimeOffset startDate, DateTimeOffset endDate);

static member DateDiffMillisecond : DateTimeOffset * DateTimeOffset -> int

Public Shared Function DateDiffMillisecond (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 millisecond boundaries between the two specified dates.

Remarks

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

DateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of millisecond boundaries between two nullable dates.

public:
 static Nullable<int> DateDiffMillisecond(Nullable<DateTime> startDate, Nullable<DateTime> endDate);

public static int? DateDiffMillisecond (DateTime? startDate, DateTime? endDate);

static member DateDiffMillisecond : Nullable<DateTime> * Nullable<DateTime> -> Nullable<int>

Public Shared Function DateDiffMillisecond (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 millisecond 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 millisecond to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF.