OracleTimeStampTZ Members

OracleTimeStampTZ members are listed in the following tables:

OracleTimeStampTZ Constructors

OracleTimeStampTZ constructors are listed in Table 14-126

Table 14-126 OracleTimeStampTZ Constructors

Constructor Description

OracleTimeStampTZ Constructors

Instantiates a new instance of OracleTimeStampTZ structure (Overloaded)

OracleTimeStampTZ Static Fields

The OracleTimeStampTZ static fields are listed in Table 14-127.

Table 14-127 OracleTimeStampTZ Static Fields

Field Description

MaxValue

Represents the maximum valid date for an OracleTimeStampTZ structure in UTC, which is December 31, 999923:59:59.999999999

MinValue

Represents the minimum valid date for an OracleTimeStampTZ structure in UTC, which is January 1, -4712 0:0:0

Null

Represents a null value that can be assigned to an instance of the OracleTimeStampTZ structure

OracleTimeStampTZ Static Methods

The OracleTimeStampTZ static methods are listed in Table 14-128.

Table 14-128 OracleTimeStampTZ Static Methods

Methods Description

Equals

Determines if two OracleTimeStampTZ values are equal (Overloaded)

GetSysDate

Gets an OracleTimeStampTZ structure that represents the current date and time

GreaterThan

Determines if the first of two OracleTimeStampTZ values is greater than the second

GreaterThanOrEqual

Determines if the first of two OracleTimeStampTZ values is greater than or equal to the second

LessThan

Determines if the first of two OracleTimeStampTZ values is less than the second

LessThanOrEqual

Determines if the first of two OracleTimeStampTZ values is less than or equal to the second

NotEquals

Determines if two OracleTimeStampTZ values are not equal

Parse

Gets an OracleTimeStampTZ structure and sets its value for date and time using the supplied string

SetPrecision

Returns a new instance of an OracleTimeStampTZ with the specified fractional second precision

OracleTimeStampTZ Static Operators

The OracleTimeStampTZ static operators are listed in Table 14-129.

Table 14-129 OracleTimeStampTZ Static Operators

Operator Description

operator +

Adds the supplied instance value to the supplied OracleTimeStampTZ and returns a new OracleTimeStampTZ structure (Overloaded)

operator ==

Determines if two OracleTimeStampTZ values are equal

operator >

Determines if the first of two OracleTimeStampTZ values is greater than the second

operator >=

Determines if the first of two OracleTimeStampTZ values is greater than or equal to the second

operator !=

Determines if two OracleTimeStampTZ values are not equal

operator <

Determines if the first of two OracleTimeStampTZ values is less than the second

operator <=

Determines if the first of two OracleTimeStampTZ values is less than or equal to the second

operator -

Subtracts the supplied instance value from the supplied OracleTimeStampTZ and returns a new OracleTimeStampTZ structure (Overloaded)

OracleTimeStampTZ Static Type Conversions

The OracleTimeStampTZ static type conversions are listed in Table 14-130.

Table 14-130 OracleTimeStampTZ Static Type Conversions

Operator Description

explicit operator OracleTimeStampTZ

Converts an instance value to an OracleTimeStampTZ structure (Overloaded)

implicit operator OracleTimeStampTZ

Converts an instance value to an OracleTimeStampTZ structure (Overloaded)

explicit operator DateTime

Converts an OracleTimeStampTZ value to a DateTime structure

OracleTimeStampTZ Properties

The OracleTimeStampTZ properties are listed in Table 14-131.

Table 14-131 OracleTimeStampTZ Properties

Properties Description

BinData

Returns an array of bytes that represents an Oracle TIMESTAMP WITH TIME ZONE in Oracle internal format

Day

Specifies the day component of an OracleTimeStampTZ in the current time zone

IsNull

Indicates whether or not the current instance has a null value

Hour

Specifies the hour component of an OracleTimeStampTZ in the current time zone

Millisecond

Specifies the millisecond component of an OracleTimeStampTZ in the current time zone

Minute

Specifies the minute component of an OracleTimeStampTZ in the current time zone

Month

Specifies the month component of an OracleTimeStampTZ in the current time zone

Nanosecond

Specifies the nanosecond component of an OracleTimeStampTZ in the current time zone

Second

Specifies the second component of an OracleTimeStampTZ in the current time zone

TimeZone

Returns the time zone of the OracleTimeStampTZ instance

Value

Returns the date and time that is stored in the OracleTimeStampTZ structure in the current time zone

Year

Specifies the year component of an OracleTimeStampTZ

OracleTimeStampTZ Methods

The OracleTimeStampTZ methods are listed in Table 14-132.

Table 14-132 OracleTimeStampTZ 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 OracleTimeStampTZ 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 OracleTimeStampTZ instance

GetDaysBetween

Subtracts an OracleTimeStampTZ from the current instance and returns an OracleIntervalDS that represents the time interval

GetHashCode

Returns a hash code for the OracleTimeStampTZ instance

GetTimeZoneOffset

Gets the time zone information in hours and minutes of the current OracleTimeStampTZ

GetYearsBetween

Subtracts an OracleTimeStampTZ from the current instance and returns an OracleIntervalYM that represents the time interval

GetType

Inherited from System.Object

ToLocalTime

Converts the current OracleTimeStampTZ instance to local time

ToOracleDate

Converts the current OracleTimeStampTZ structure to an OracleDate structure

ToOracleTimeStampLTZ

Converts the current OracleTimeStampTZ structure to an OracleTimeStampLTZ structure

ToOracleTimeStamp

Converts the current OracleTimeStampTZ structure to an OracleTimeStamp structure

ToString

Converts the current OracleTimeStampTZ structure to a string

ToUniversalTime

Converts the current datetime to Coordinated Universal Time (UTC)