OracleTimeSpan Struct

Definition

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
OracleTimeSpan
Implements

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