OracleDateTime Struct

Definition

Namespace:

System.Data.OracleClient

Assembly:

System.Data.OracleClient.dll

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

C#

public struct OracleDateTime : IComparable, System.Data.SqlTypes.INullable

Inheritance

Object

ValueType

OracleDateTime

Implements

INullable IComparable

Remarks

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.

Constructors

OracleDateTime(DateTime)	Initializes a new instance of the OracleDateTime structure with the specified DateTime.
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, 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, 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(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)	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)	Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, and day 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.

Fields

MaxValue	Represents the maximum valid date value for an OracleDateTime structure.
MinValue	Represents the minimum valid date value for an OracleDateTime structure.
Null	Represents a null value that can be assigned to the Value property of an instance of the OracleDateTime structure.

Properties

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.

Methods

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.
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.
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.

Operators

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.

Applies to