OracleDateTime Struct

Definition

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

public value class OracleDateTime : IComparable, System::Data::SqlTypes::INullable
public struct OracleDateTime : IComparable, System.Data.SqlTypes.INullable
type OracleDateTime = struct
    interface INullable
Public Structure OracleDateTime
Implements IComparable, INullable
Inheritance
OracleDateTime
Implements

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)

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.

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