SqlMethods.DateDiffMillisecond Method
Definition
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.
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.
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
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.
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
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 -> intPublic Shared Function DateDiffMillisecond (startDate As DateTime, endDate As DateTime) As IntegerParameters
- startDate
- DateTime
The start date for the time period.
- endDate
- DateTime
The end date for the time period.
Returns
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.
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
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 -> intPublic Shared Function DateDiffMillisecond (startDate As DateTimeOffset, endDate As DateTimeOffset) As IntegerParameters
- startDate
- DateTimeOffset
The start date for the time period.
- endDate
- DateTimeOffset
The end date for the time period.
Returns
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.
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
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
Returns
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.
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
.NET feedback
.NET is an open source project. Select a link to provide feedback: