OracleDateTime OracleDateTime OracleDateTime 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
OracleDateTimeOracleDateTimeOracleDateTimeOracleDateTime
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(OracleDateTime) OracleDateTime(OracleDateTime) OracleDateTime(OracleDateTime) OracleDateTime(OracleDateTime)

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

OracleDateTime(DateTime) OracleDateTime(DateTime) OracleDateTime(DateTime) OracleDateTime(DateTime)

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

OracleDateTime(Int64) OracleDateTime(Int64) OracleDateTime(Int64) OracleDateTime(Int64)

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

OracleDateTime(Int32, Int32, Int32) OracleDateTime(Int32, Int32, Int32) OracleDateTime(Int32, Int32, Int32) 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) OracleDateTime(Int32, Int32, Int32, Calendar) OracleDateTime(Int32, Int32, Int32, Calendar) 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) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32) 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) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Calendar) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Calendar) 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) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32) 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) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32, Calendar) OracleDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32, Calendar) 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.

Fields

MaxValue MaxValue MaxValue MaxValue

Represents the maximum valid date value for an OracleDateTime structure.

MinValue MinValue MinValue MinValue

Represents the minimum valid date value for an OracleDateTime structure.

Null Null Null Null

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

Properties

Day Day Day Day

Gets the value of the OracleDateTime structure as a day.

Hour Hour Hour Hour

Gets the value of the OracleDateTime structure as an hour.

IsNull IsNull IsNull IsNull

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

Millisecond Millisecond Millisecond Millisecond

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

Minute Minute Minute Minute

Gets the value of the OracleDateTime structure as a minute.

Month Month Month Month

Gets the value of the OracleDateTime structure as a month.

Second Second Second Second

Gets the value of the OracleDateTime structure as a second.

Value Value Value Value

Gets the value of the OracleDateTime structure.

Year Year Year Year

Gets the value of the OracleDateTime structure as a year.

Methods

CompareTo(Object) CompareTo(Object) CompareTo(Object) CompareTo(Object)

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

Equals(Object) Equals(Object) Equals(Object) Equals(Object)

Compares the supplied object parameter to the Value property of the OracleDateTime object.

Equals(OracleDateTime, OracleDateTime) Equals(OracleDateTime, OracleDateTime) Equals(OracleDateTime, OracleDateTime) Equals(OracleDateTime, OracleDateTime)

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

GetHashCode() GetHashCode() GetHashCode() GetHashCode()

Gets the hash code for this instance.

GreaterThan(OracleDateTime, OracleDateTime) GreaterThan(OracleDateTime, OracleDateTime) GreaterThan(OracleDateTime, OracleDateTime) GreaterThan(OracleDateTime, OracleDateTime)

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

GreaterThanOrEqual(OracleDateTime, OracleDateTime) GreaterThanOrEqual(OracleDateTime, OracleDateTime) GreaterThanOrEqual(OracleDateTime, OracleDateTime) GreaterThanOrEqual(OracleDateTime, OracleDateTime)

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

LessThan(OracleDateTime, OracleDateTime) LessThan(OracleDateTime, OracleDateTime) LessThan(OracleDateTime, OracleDateTime) LessThan(OracleDateTime, OracleDateTime)

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

LessThanOrEqual(OracleDateTime, OracleDateTime) LessThanOrEqual(OracleDateTime, OracleDateTime) LessThanOrEqual(OracleDateTime, OracleDateTime) LessThanOrEqual(OracleDateTime, OracleDateTime)

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

NotEquals(OracleDateTime, OracleDateTime) NotEquals(OracleDateTime, OracleDateTime) NotEquals(OracleDateTime, OracleDateTime) NotEquals(OracleDateTime, OracleDateTime)

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

Parse(String) Parse(String) Parse(String) Parse(String)

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

ToString() ToString() ToString() ToString()

Converts this OracleDateTime structure to a String.

Operators

Equality(OracleDateTime, OracleDateTime) Equality(OracleDateTime, OracleDateTime) Equality(OracleDateTime, OracleDateTime) Equality(OracleDateTime, OracleDateTime)

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

Explicit(String to OracleDateTime) Explicit(String to OracleDateTime) Explicit(String to OracleDateTime) Explicit(String to OracleDateTime)

Converts a String to an OracleDateTime structure.

Explicit(OracleDateTime to DateTime) Explicit(OracleDateTime to DateTime) Explicit(OracleDateTime to DateTime) Explicit(OracleDateTime to DateTime)

Converts an OracleDateTime structure to a DateTime structure.

GreaterThan(OracleDateTime, OracleDateTime) GreaterThan(OracleDateTime, OracleDateTime) GreaterThan(OracleDateTime, OracleDateTime) GreaterThan(OracleDateTime, OracleDateTime)

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

GreaterThanOrEqual(OracleDateTime, OracleDateTime) GreaterThanOrEqual(OracleDateTime, OracleDateTime) GreaterThanOrEqual(OracleDateTime, OracleDateTime) GreaterThanOrEqual(OracleDateTime, OracleDateTime)

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

Inequality(OracleDateTime, OracleDateTime) Inequality(OracleDateTime, OracleDateTime) Inequality(OracleDateTime, OracleDateTime) Inequality(OracleDateTime, OracleDateTime)

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

LessThan(OracleDateTime, OracleDateTime) LessThan(OracleDateTime, OracleDateTime) LessThan(OracleDateTime, OracleDateTime) LessThan(OracleDateTime, OracleDateTime)

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

LessThanOrEqual(OracleDateTime, OracleDateTime) LessThanOrEqual(OracleDateTime, OracleDateTime) LessThanOrEqual(OracleDateTime, OracleDateTime) LessThanOrEqual(OracleDateTime, OracleDateTime)

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

Applies to