OracleDateTime Structure
Represents date and time data ranging in value from January 1, 4712 BC to December 31, 4712 AD.
Assembly: System.Data.OracleClient (in System.Data.OracleClient.dll)
| Name | Description | |
|---|---|---|
![]() | OracleDateTime(DateTime) | Initializes a new instance of the OracleDateTime structure with the specified System::DateTime. |
![]() | OracleDateTime(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. |
![]() | OracleDateTime(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. |
![]() | OracleDateTime(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. |
![]() | OracleDateTime(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. |
![]() | OracleDateTime(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. |
![]() | OracleDateTime(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. |
![]() | OracleDateTime(Int64) | Initializes a new instance of the OracleDateTime structure using the supplied number of ticks. |
![]() | OracleDateTime(OracleDateTime) | Initializes a new instance of the OracleDateTime structure from an existing OracleDateTime object. |
| Name | Description | |
|---|---|---|
![]() | Day | Gets the value of the OracleDateTime structure as a day. |
![]() | Hour | Gets the value of the OracleDateTime structure as an hour. |
![]() | IsNull | Gets a value indicating whether the Value property of the OracleDateTime structure is null. |
![]() | Millisecond | Gets the milliseconds component of the date represented by this instance. |
![]() | Minute | Gets the value of the OracleDateTime structure as a minute. |
![]() | Month | Gets the value of the OracleDateTime structure as a month. |
![]() | Second | Gets the value of the OracleDateTime structure as a second. |
![]() | Value | Gets the value of the OracleDateTime structure. |
![]() | Year | Gets the value of the OracleDateTime structure as a year. |
| Name | Description | |
|---|---|---|
![]() | CompareTo(Object^) | Compares this OracleDateTime 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 OracleDateTime object.(Overrides ValueType::Equals(Object^).) |
![]() ![]() | Equals(OracleDateTime, OracleDateTime) | Performs a logical comparison of two OracleDateTime structures to determine whether they are equal. |
![]() | GetHashCode() | Gets the hash code for this instance.(Overrides ValueType::GetHashCode().) |
![]() | GetType() | |
![]() ![]() | GreaterThan(OracleDateTime, OracleDateTime) | Compares two instances of OracleDateTime to determine whether the first is greater than the second. |
![]() ![]() | GreaterThanOrEqual(OracleDateTime, OracleDateTime) | Compares two instances of OracleDateTime to determine whether the first is greater than or equal to the second. |
![]() ![]() | LessThan(OracleDateTime, OracleDateTime) | Compares two instances of OracleDateTime to determine whether the first is less than the second. |
![]() ![]() | LessThanOrEqual(OracleDateTime, OracleDateTime) | Compares two instances of OracleDateTime to determine whether the first is less than or equal to the second. |
![]() ![]() | NotEquals(OracleDateTime, OracleDateTime) | Performs a logical comparison of two instances of OracleDateTime to determine if they are not equal. |
![]() ![]() | Parse(String^) | Converts the specified String representation of a date and time to its OracleDateTime equivalent. |
![]() | ToString() | Converts this OracleDateTime structure to a String.(Overrides ValueType::ToString().) |
| Name | Description | |
|---|---|---|
![]() ![]() | Equality(OracleDateTime, OracleDateTime) | Performs a logical comparison of two OracleDateTime structures to determine if they are equal. |
![]() ![]() | Explicit(OracleDateTime to DateTime) | Converts an OracleDateTime structure to a DateTime structure. |
![]() ![]() | Explicit(String^ to OracleDateTime) | Converts a String to an OracleDateTime structure. |
![]() ![]() | GreaterThan(OracleDateTime, OracleDateTime) | Compares two instances of OracleDateTime to determine if the first is greater than the second. |
![]() ![]() | GreaterThanOrEqual(OracleDateTime, OracleDateTime) | Compares two instances of OracleDateTime to determine if the first is greater than or equal to the second. |
![]() ![]() | Inequality(OracleDateTime, OracleDateTime) | Performs a logical comparison of two instances of OracleDateTime to determine if they are equal. |
![]() ![]() | LessThan(OracleDateTime, OracleDateTime) | Compares two instances of OracleDateTime to determine if the first is less than the second. |
![]() ![]() | LessThanOrEqual(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.
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.




