OracleDateTime Structure

OracleDateTime Structure

 

Represents date and time data ranging in value from January 1, 4712 BC to December 31, 4712 AD.

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

[<Sealed>]
type OracleDateTime = 
    struct
        interface IComparable
        interface INullable
    end

NameDescription
System_CAPS_pubmethodOracleDateTime(DateTime)

Initializes a new instance of the OracleDateTime structure with the specified System.DateTime.

System_CAPS_pubmethodOracleDateTime(Int32, Int32, Int32)

Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, and day of the new structure.

System_CAPS_pubmethodOracleDateTime(Int32, Int32, Int32, Calendar)

Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, and calendar of the new structure.

System_CAPS_pubmethodOracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32)

Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, and second of the new structure.

System_CAPS_pubmethodOracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Calendar)

Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, and second for the specified calendar of the new structure.

System_CAPS_pubmethodOracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32)

Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, second, and millisecond of the new structure.

System_CAPS_pubmethodOracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32, Calendar)

Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, second, and millisecond for the specified calendar of the new structure.

System_CAPS_pubmethodOracleDateTime(Int64)

Initializes a new instance of the OracleDateTime structure using the supplied number of ticks.

System_CAPS_pubmethodOracleDateTime(OracleDateTime)

Initializes a new instance of the OracleDateTime structure from an existing OracleDateTime object.

NameDescription
System_CAPS_pubpropertyDay

Gets the value of the OracleDateTime structure as a day.

System_CAPS_pubpropertyHour

Gets the value of the OracleDateTime structure as an hour.

System_CAPS_pubpropertyIsNull

Gets a value indicating whether the Value property of the OracleDateTime structure is null.

System_CAPS_pubpropertyMillisecond

Gets the milliseconds component of the date represented by this instance.

System_CAPS_pubpropertyMinute

Gets the value of the OracleDateTime structure as a minute.

System_CAPS_pubpropertyMonth

Gets the value of the OracleDateTime structure as a month.

System_CAPS_pubpropertySecond

Gets the value of the OracleDateTime structure as a second.

System_CAPS_pubpropertyValue

Gets the value of the OracleDateTime structure.

System_CAPS_pubpropertyYear

Gets the value of the OracleDateTime structure as a year.

NameDescription
System_CAPS_pubmethodCompareTo(Object)

Compares this OracleDateTime structure to the supplied object and returns an indication of their relative values.

System_CAPS_pubmethodEquals(Object)

Compares the supplied object parameter to the Value property of the OracleDateTime object.(Overrides ValueType.Equals(Object).)

System_CAPS_pubmethodSystem_CAPS_staticEquals(OracleDateTime, OracleDateTime)

Performs a logical comparison of two OracleDateTime structures to determine whether they are equal.

System_CAPS_pubmethodGetHashCode()

Gets the hash code for this instance.(Overrides ValueType.GetHashCode().)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodSystem_CAPS_staticGreaterThan(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine whether the first is greater than the second.

System_CAPS_pubmethodSystem_CAPS_staticGreaterThanOrEqual(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine whether the first is greater than or equal to the second.

System_CAPS_pubmethodSystem_CAPS_staticLessThan(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine whether the first is less than the second.

System_CAPS_pubmethodSystem_CAPS_staticLessThanOrEqual(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine whether the first is less than or equal to the second.

System_CAPS_pubmethodSystem_CAPS_staticNotEquals(OracleDateTime, OracleDateTime)

Performs a logical comparison of two instances of OracleDateTime to determine if they are not equal.

System_CAPS_pubmethodSystem_CAPS_staticParse(String)

Converts the specified String representation of a date and time to its OracleDateTime equivalent.

System_CAPS_pubmethodToString()

Converts this OracleDateTime structure to a String.(Overrides ValueType.ToString().)

NameDescription
System_CAPS_pubfieldSystem_CAPS_staticMaxValue

Represents the maximum valid date value for an OracleDateTime structure.

System_CAPS_pubfieldSystem_CAPS_staticMinValue

Represents the minimum valid date value for an OracleDateTime structure.

System_CAPS_pubfieldSystem_CAPS_staticNull

Represents a null value that can be assigned to the Value property of an instance of the OracleDateTime structure.

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticEquality(OracleDateTime, OracleDateTime)

Performs a logical comparison of two OracleDateTime structures to determine if they are equal.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(OracleDateTime to DateTime)

Converts an OracleDateTime structure to a DateTime structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(String to OracleDateTime)

Converts a String to an OracleDateTime structure.

System_CAPS_puboperatorSystem_CAPS_staticGreaterThan(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine if the first is greater than the second.

System_CAPS_puboperatorSystem_CAPS_staticGreaterThanOrEqual(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine if the first is greater than or equal to the second.

System_CAPS_puboperatorSystem_CAPS_staticInequality(OracleDateTime, OracleDateTime)

Performs a logical comparison of two instances of OracleDateTime to determine if they are equal.

System_CAPS_puboperatorSystem_CAPS_staticLessThan(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine if the first is less than the second.

System_CAPS_puboperatorSystem_CAPS_staticLessThanOrEqual(OracleDateTime, OracleDateTime)

Compares two instances of OracleDateTime to determine if the first is less than or equal to the second.

To obtain an OracleDateTime object, call the GetOracleDateTime method.

The minimum valid date for an OracleDateTime structure is 1/1/0001 00:00:00. However, Oracle supports dates as early as January 1, 4712 BC. To bind BC dates, use a String parameter and the Oracle TO_DATE or TO_CHAR conversion functions for input and output parameters respectively.

.NET Framework
Available since 1.1

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

Return to top
Show:
© 2016 Microsoft