Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

OracleDateTime Structure

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

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)
public struct OracleDateTime : IComparable, 
	INullable

The OracleDateTime type exposes the following members.

  NameDescription
Public methodOracleDateTime(DateTime)Initializes a new instance of the OracleDateTime structure with the specified System.DateTime.
Public methodOracleDateTime(Int64)Initializes a new instance of the OracleDateTime structure using the supplied number of ticks.
Public methodOracleDateTime(OracleDateTime)Initializes a new instance of the OracleDateTime structure from an existing OracleDateTime object.
Public methodOracleDateTime(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.
Public methodOracleDateTime(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.
Public methodOracleDateTime(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.
Public methodOracleDateTime(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.
Public methodOracleDateTime(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.
Public methodOracleDateTime(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.
Top
  NameDescription
Public propertyDayGets the value of the OracleDateTime structure as a day.
Public propertyHourGets the value of the OracleDateTime structure as an hour.
Public propertyIsNullGets a value indicating whether the Value property of the OracleDateTime structure is null.
Public propertyMillisecondGets the milliseconds component of the date represented by this instance.
Public propertyMinuteGets the value of the OracleDateTime structure as a minute.
Public propertyMonthGets the value of the OracleDateTime structure as a month.
Public propertySecondGets the value of the OracleDateTime structure as a second.
Public propertyValueGets the value of the OracleDateTime structure.
Public propertyYearGets the value of the OracleDateTime structure as a year.
Top
  NameDescription
Public methodCompareToCompares this OracleDateTime structure to the supplied object and returns an indication of their relative values.
Public methodEquals(Object)Compares the supplied object parameter to the Value property of the OracleDateTime object. (Overrides ValueType.Equals(Object).)
Public methodStatic memberEquals(OracleDateTime, OracleDateTime)Performs a logical comparison of two OracleDateTime structures to determine whether they are equal.
Public methodGetHashCodeGets the hash code for this instance. (Overrides ValueType.GetHashCode().)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodStatic memberGreaterThanCompares two instances of OracleDateTime to determine whether the first is greater than the second.
Public methodStatic memberGreaterThanOrEqualCompares two instances of OracleDateTime to determine whether the first is greater than or equal to the second.
Public methodStatic memberLessThanCompares two instances of OracleDateTime to determine whether the first is less than the second.
Public methodStatic memberLessThanOrEqualCompares two instances of OracleDateTime to determine whether the first is less than or equal to the second.
Public methodStatic memberNotEqualsPerforms a logical comparison of two instances of OracleDateTime to determine if they are not equal.
Public methodStatic memberParseConverts the specified String representation of a date and time to its OracleDateTime equivalent.
Public methodToStringConverts this OracleDateTime structure to a String. (Overrides ValueType.ToString().)
Top
  NameDescription
Public operatorStatic memberEqualityPerforms a logical comparison of two OracleDateTime structures to determine if they are equal.
Public operatorStatic memberExplicit(OracleDateTime to DateTime)Converts an OracleDateTime structure to a DateTime structure.
Public operatorStatic memberExplicit(String to OracleDateTime)Converts a String to an OracleDateTime structure.
Public operatorStatic memberGreaterThanCompares two instances of OracleDateTime to determine if the first is greater than the second.
Public operatorStatic memberGreaterThanOrEqualCompares two instances of OracleDateTime to determine if the first is greater than or equal to the second.
Public operatorStatic memberInequalityPerforms a logical comparison of two instances of OracleDateTime to determine if they are equal.
Public operatorStatic memberLessThanCompares two instances of OracleDateTime to determine if the first is less than the second.
Public operatorStatic memberLessThanOrEqualCompares two instances of OracleDateTime to determine if the first is less than or equal to the second.
Top
  NameDescription
Public fieldStatic memberMaxValueRepresents the maximum valid date value for an OracleDateTime structure.
Public fieldStatic memberMinValueRepresents the minimum valid date value for an OracleDateTime structure.
Public fieldStatic memberNullRepresents a null value that can be assigned to the Value property of an instance of the OracleDateTime structure.
Top

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.

.NET Framework

Supported in: 4.5.1, 4.5, 4, 3.5, 3.0, 2.0, 1.1

Windows Phone 8.1, Windows Phone 8, Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft. All rights reserved.