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)
The OracleDateTime type exposes the following members.
| Name | Description | |
|---|---|---|
![]() | OracleDateTime(DateTime) | Initializes a new instance of the OracleDateTime structure with the specified System::DateTime. |
![]() | 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. |
![]() | 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. |
| 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 | 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. |
![]() | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetHashCode | Gets the hash code for this instance. (Overrides ValueType::GetHashCode().) |
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() ![]() | GreaterThan | Compares two instances of OracleDateTime to determine whether the first is greater than the second. |
![]() ![]() | GreaterThanOrEqual | Compares two instances of OracleDateTime to determine whether the first is greater than or equal to the second. |
![]() ![]() | LessThan | Compares two instances of OracleDateTime to determine whether the first is less than the second. |
![]() ![]() | LessThanOrEqual | Compares two instances of OracleDateTime to determine whether the first is less than or equal to the second. |
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() ![]() | NotEquals | Performs a logical comparison of two instances of OracleDateTime to determine if they are not equal. |
![]() ![]() | Parse | 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 | 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 | Compares two instances of OracleDateTime to determine if the first is greater than the second. |
![]() ![]() | GreaterThanOrEqual | Compares two instances of OracleDateTime to determine if the first is greater than or equal to the second. |
![]() ![]() | Inequality | Performs a logical comparison of two instances of OracleDateTime to determine if they are equal. |
![]() ![]() | LessThan | Compares two instances of OracleDateTime to determine if the first is less than the second. |
![]() ![]() | LessThanOrEqual | 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.
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
