OracleTimeSpan Struct

Reference

Definition

Namespace:: System.Data.OracleClient

Assembly:: System.Data.OracleClient.dll

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.

Represents a time interval and corresponds to the Oracle 9i INTERVAL DAY TO SECOND data type.

public value class OracleTimeSpan : IComparable, System::Data::SqlTypes::INullable

public struct OracleTimeSpan : IComparable, System.Data.SqlTypes.INullable

type OracleTimeSpan = struct
    interface INullable

Public Structure OracleTimeSpan
Implements IComparable, INullable

Inheritance: Object

ValueType
OracleTimeSpan

Implements: INullable IComparable

Remarks

The Oracle INTERVAL DAY TO SECOND data type (Oracle 9i or later) contains an interval of time in days, hours, minutes, and seconds, and has a fixed size of 11 bytes.

To obtain an OracleTimeSpan object, call the GetOracleTimeSpan method.

Constructors

OracleTimeSpan(Int32, Int32, Int32)	Initializes a new OracleTimeSpan structure to a specified number of hours, minutes, and seconds.
OracleTimeSpan(Int32, Int32, Int32, Int32)	Initializes a new OracleTimeSpan structure to a specified number of days, hours, minutes, and seconds.
OracleTimeSpan(Int32, Int32, Int32, Int32, Int32)	Initializes a new OracleTimeSpan structure to a specified number of days, hours, minutes, seconds, and milliseconds.
OracleTimeSpan(Int64)	Initializes a new OracleTimeSpan structure to the specified number of ticks.
OracleTimeSpan(OracleTimeSpan)	Initializes a new OracleTimeSpan structure from an existing one.
OracleTimeSpan(TimeSpan)	Initializes a new instance of the OracleTimeSpan structure with the specified TimeSpan.

Fields

MaxValue	Represents the maximum valid date value for an OracleTimeSpan structure.
MinValue	Represents the minimum valid date value for an OracleTimeSpan structure.
Null	Represents a null value that can be assigned to the Value property of an instance of the OracleTimeSpan structure.

Properties

Days	Gets the number of whole days represented by this instance.
Hours	Gets the number of whole hours represented by this instance.
IsNull	Gets a value indicating whether the Value property of the OracleTimeSpan structure is null.
Milliseconds	Gets the number of whole milliseconds represented by this instance.
Minutes	Gets the number of whole minutes represented by this instance.
Seconds	Gets the number of whole seconds represented by this instance.
Value	Gets the value of the OracleTimeSpan structure.

Methods

CompareTo(Object)	Compares this OracleTimeSpan structure to the supplied object and returns an indication of their relative values.
Equals(Object)	Compares the supplied object parameter to the Value property of the OracleTimeSpan object.
Equals(OracleTimeSpan, OracleTimeSpan)	Performs a logical comparison of two OracleTimeSpan structures to determine whether they are equal.
GetHashCode()	Gets the hash code for this instance.
GreaterThan(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is greater than the second.
GreaterThanOrEqual(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is greater than or equal to the second.
LessThan(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is less than the second.
LessThanOrEqual(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is less than or equal to the second.
NotEquals(OracleTimeSpan, OracleTimeSpan)	Performs a logical comparison of two instances of OracleTimeSpan to determine whether they are not equal.
Parse(String)	Converts the specified String representation of a date and time to its OracleTimeSpan equivalent.
ToString()	Converts this OracleTimeSpan structure to a String.

Operators

Equality(OracleTimeSpan, OracleTimeSpan)	Performs a logical comparison of two OracleTimeSpan structures to determine whether they are equal.
Explicit(OracleTimeSpan to TimeSpan)	Converts an OracleTimeSpan structure to a TimeSpan structure.
Explicit(String to OracleTimeSpan)	Converts a string to an OracleTimeSpan structure.
GreaterThan(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is greater than the second.
GreaterThanOrEqual(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is greater than or equal to the second.
Inequality(OracleTimeSpan, OracleTimeSpan)	Performs a logical comparison of two instances of OracleTimeSpan to determine whether they are equal.
LessThan(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is less than the second.
LessThanOrEqual(OracleTimeSpan, OracleTimeSpan)	Compares two instances of OracleTimeSpan to determine whether the first is less than or equal to the second.

Applies to

Share via