Export (0) Print
Expand All

OracleTimeSpan Structure

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

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

public struct OracleTimeSpan : IComparable, 
	INullable

The OracleTimeSpan type exposes the following members.

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

  NameDescription
Public propertyDaysGets the number of whole days represented by this instance.
Public propertyHoursGets the number of whole hours represented by this instance.
Public propertyIsNullGets a value indicating whether the Value property of the OracleTimeSpan structure is null.
Public propertyMillisecondsGets the number of whole milliseconds represented by this instance.
Public propertyMinutesGets the number of whole minutes represented by this instance.
Public propertySecondsGets the number of whole seconds represented by this instance.
Public propertyValueGets the value of the OracleTimeSpan structure.
Top

  NameDescription
Public methodCompareToCompares this OracleTimeSpan structure to the supplied object and returns an indication of their relative values.
Public methodEquals(Object)Compares the supplied object parameter to the Value property of the OracleTimeSpan object. (Overrides ValueType.Equals(Object).)
Public methodStatic memberEquals(OracleTimeSpan, OracleTimeSpan)Performs a logical comparison of two OracleTimeSpan structures to determine whether they are equal.
Public methodGetHashCodeGets the hash code for this instance. (Overrides ValueType.GetHashCode().)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodStatic memberGreaterThanCompares two instances of OracleTimeSpan to determine whether the first is greater than the second.
Public methodStatic memberGreaterThanOrEqualCompares two instances of OracleTimeSpan to determine whether the first is greater than or equal to the second.
Public methodStatic memberLessThanCompares two instances of OracleTimeSpan to determine whether the first is less than the second.
Public methodStatic memberLessThanOrEqualCompares two instances of OracleTimeSpan to determine whether the first is less than or equal to the second.
Public methodStatic memberNotEqualsPerforms a logical comparison of two instances of OracleTimeSpan to determine whether they are not equal.
Public methodStatic memberParseConverts the specified String representation of a date and time to its OracleTimeSpan equivalent.
Public methodToStringConverts this OracleTimeSpan structure to a String. (Overrides ValueType.ToString().)
Top

  NameDescription
Public operatorStatic memberEqualityPerforms a logical comparison of two OracleTimeSpan structures to determine whether they are equal.
Public operatorStatic memberExplicit(OracleTimeSpan to TimeSpan)Converts an OracleTimeSpan structure to a TimeSpan structure.
Public operatorStatic memberExplicit(String to OracleTimeSpan)Converts a string to an OracleTimeSpan structure.
Public operatorStatic memberGreaterThanCompares two instances of OracleTimeSpan to determine whether the first is greater than the second.
Public operatorStatic memberGreaterThanOrEqualCompares two instances of OracleTimeSpan to determine whether the first is greater than or equal to the second.
Public operatorStatic memberInequalityPerforms a logical comparison of two instances of OracleTimeSpan to determine whether they are equal.
Public operatorStatic memberLessThanCompares two instances of OracleTimeSpan to determine whether the first is less than the second.
Public operatorStatic memberLessThanOrEqualCompares two instances of OracleTimeSpan to determine whether the first is less than or equal to the second.
Top

  NameDescription
Public fieldStatic memberMaxValueRepresents the maximum valid date value for an OracleTimeSpan structure.
Public fieldStatic memberMinValueRepresents the minimum valid date value for an OracleTimeSpan structure.
Public fieldStatic memberNullRepresents a null value that can be assigned to the Value property of an instance of the OracleTimeSpan structure.
Top

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.

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0, 1.1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft