OracleTimeStamp Members

OracleTimeStamp members are listed in the following tables:

OracleTimeStamp Constructors

OracleTimeStamp constructors are listed in Table 14-101

Table 101 OracleTimeStamp Constructors

Constructor Description
OracleTimeStamp Constructors Instantiates a new instance of OracleTimeStamp structure (Overloaded)

OracleTimeStamp Static Fields

The OracleTimeStamp static fields are listed in Table 14-102.

Table 102 OracleTimeStamp Static Fields

Field Description
MaxValue Represents the maximum valid date for an OracleTimeStamp structure, which is December 31, 9999 23:59:59.999999999
MinValue Represents the minimum valid date for an OracleTimeStamp structure, which is January 1, -4712 0:0:0
Null Represents a null value that can be assigned to an instance of the OracleTimeStamp structure

OracleTimeStamp Static Methods

The OracleTimeStamp static methods are listed in Table 14-103.

Table 103 OracleTimeStamp Static Methods

Methods Description
Equals Determines if two OracleTimeStamp values are equal (Overloaded)
GreaterThan Determines if the first of two OracleTimeStamp values is greater than the second
GreaterThanOrEqual Determines if the first of two OracleTimeStamp values is greater than or equal to the second
LessThan Determines if the first of two OracleTimeStamp values is less than the second
LessThanOrEqual Determines if the first of two OracleTimeStamp values is less than or equal to the second
NotEquals Determines if two OracleTimeStamp values are not equal
GetSysDate Gets an OracleTimeStamp structure that represents the current date and time
Parse Gets an OracleTimeStamp structure and sets its value using the supplied string
SetPrecision Returns a new instance of an OracleTimeStamp with the specified fractional second precision

OracleTimeStamp Static Operators

The OracleTimeStamp static operators are listed in Table 14-104.

Table 104 OracleTimeStamp Static Operators

Operator Description
operator + Adds the supplied instance value to the supplied OracleTimeStamp and returns a new OracleTimeStamp structure (Overloaded)
operator == Determines if two OracleTimeStamp values are equal
operator > Determines if the first of two OracleTimeStamp values is greater than the second
operator >= Determines if the first of two OracleTimeStamp values is greater than or equal to the second
operator != Determines if the two OracleTimeStamp values are not equal
operator < Determines if the first of two OracleTimeStamp values is less than the second
operator <= Determines if the first of two OracleTimeStamp values is less than or equal to the second
operator - Subtracts the supplied instance value from the supplied OracleTimeStamp and returns a new OracleTimeStamp structure (Overloaded)

OracleTimeStamp Static Type Conversions

The OracleTimeStamp static type conversions are listed in Table 14-105.

Table 105 OracleTimeStamp Static Type Conversions

Operator Description
explicit operator OracleTimeStamp Converts an instance value to an OracleTimeStamp structure (Overloaded)
implicit operator OracleTimeStamp Converts an instance value to an OracleTimeStamp structure (Overloaded)
explicit operator DateTime Converts an OracleTimeStamp value to a DateTime structure

OracleTimeStamp Properties

The OracleTimeStamp properties are listed in Table 14-106.

Table 106 OracleTimeStamp Properties

Properties Description
BinData Returns an array of bytes that represents an Oracle TIMESTAMP in Oracle internal format
Day Specifies the day component of an OracleTimeStamp
IsNull Indicates whether or not the OracleTimeStamp instance has a null value
Hour Specifies the hour component of an OracleTimeStamp
Millisecond Specifies the millisecond component of an OracleTimeStamp
Minute Specifies the minute component of an OracleTimeStamp
Month Specifies the month component of an OracleTimeStamp
Nanosecond Specifies the nanosecond component of an OracleTimeStamp
Second Specifies the second component of an OracleTimeStamp
Value Specifies the date and time that is stored in the OracleTimeStamp structure
Year Specifies the year component of an OracleTimeStamp

OracleTimeStamp Methods

The OracleTimeStamp methods are listed in Table 14-107.

Table 107 OracleTimeStamp Methods

Methods Description
AddDays Adds the supplied number of days to the current instance
AddHours Adds the supplied number of hours to the current instance
AddMilliseconds Adds the supplied number of milliseconds to the current instance
AddMinutes Adds the supplied number of minutes to the current instance
AddMonths Adds the supplied number of months to the current instance
AddNanoseconds Adds the supplied number of nanoseconds to the current instance
AddSeconds Adds the supplied number of seconds to the current instance
AddYears Adds the supplied number of years to the current instance
CompareTo Compares the current OracleTimeStamp instance to an object, and returns an integer that represents their relative values
Equals Determines whether or not an object has the same date and time as the current OracleTimeStamp instance (Overloaded)
GetHashCode Returns a hash code for the OracleTimeStamp instance
GetDaysBetween Subtracts an OracleTimeStamp value from the current instance and returns an OracleIntervalDS that represents the time difference between the supplied OracleTimeStamp and the current instance
GetYearsBetween Subtracts value1 from the current instance and returns an OracleIntervalYM that represents the difference between value1 and the current instance using OracleIntervalYM
GetType Inherited from System.Object
ToOracleDate Converts the current OracleTimeStamp structure to an OracleDate structure
ToOracleTimeStampLTZ Converts the current OracleTimeStamp structure to an OracleTimeStampLTZ structure
ToOracleTimeStampTZ Converts the current OracleTimeStamp structure to an OracleTimeStampTZ structure
ToString Returns the string representation of the current instance. (Overloaded)

See Also: