14.9.1 OracleTimeStampLTZ Members

OracleTimeStampLTZ members are listed in the following tables:

OracleTimeStampLTZ Constructors

OracleTimeStampLTZ constructors are listed in Table 14-113

Table 14-113 OracleTimeStampLTZConstructors

Constructor Description

OracleTimeStampLTZ Constructors

Instantiates a new instance of OracleTimeStampLTZ structure (Overloaded)

OracleTimeStampLTZ Static Fields

The OracleTimeStampLTZ static fields are listed in Table 14-114.

Table 14-114 OracleTimeStampLTZ Static Fields

Field Description

MaxValue

Represents the maximum valid date for an OracleTimeStampLTZ structure, which is December 31, 9999 23:59:59.999999999

MinValue

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

Null

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

OracleTimeStampLTZ Static Methods

The OracleTimeStampLTZ static methods are listed in Table 14-115.

Table 14-115 OracleTimeStampLTZ Static Methods

Methods Description

Equals

Determines if two OracleTimeStampLTZ values are equal (Overloaded)

GetLocalTimeZoneName

Gets the client's local time zone name

GetLocalTimeZoneOffset

Gets the client's local time zone offset relative to UTC

GetSysDate

Gets an OracleTimeStampLTZ structure that represents the current date and time

GreaterThan

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

GreaterThanOrEqual

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

LessThan

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

LessThanOrEqual

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

NotEquals

Determines if two OracleTimeStampLTZ values are not equal

Parse

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

SetPrecision

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

OracleTimeStampLTZ Static Operators

The OracleTimeStampLTZ static operators are listed in Table 14-116.

Table 14-116 OracleTimeStampLTZ Static Operators

Operator Description

operator +

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

operator ==

Determines if two OracleTimeStampLTZ values are equal

operator >

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

operator >=

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

operator !=

Determines if two OracleTimeStampLTZ values are not equal

operator <

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

operator <=

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

operator -

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

OracleTimeStampLTZ Static Type Conversions

The OracleTimeStampLTZ static type conversions are listed in Table 14-117.

Table 14-117 OracleTimeStampLTZ Static Type Conversions

Operator Description

explicit operator OracleTimeStampLTZ

Converts an instance value to an OracleTimeStampLTZ structure (Overloaded)

implicit operator OracleTimeStampLTZ

Converts an instance value to an OracleTimeStampLTZ structure (Overloaded)

explicit operator DateTime

Converts an OracleTimeStampLTZ value to a DateTime structure

OracleTimeStampLTZ Properties

The OracleTimeStampLTZ properties are listed in Table 14-118.

Table 14-118 OracleTimeStampLTZ Properties

Properties Description

BinData

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

Day

Specifies the day component of an OracleTimeStampLTZ

IsNull

Indicates whether or not the OracleTimeStampLTZ instance has a null value

Hour

Specifies the hour component of an OracleTimeStampLTZ

Millisecond

Specifies the millisecond component of an OracleTimeStampLTZ

Minute

Specifies the minute component of an OracleTimeStampLTZ

Month

Specifies the month component of an OracleTimeStampLTZ

Nanosecond

Specifies the nanosecond component of an OracleTimeStampLTZ

Second

Specifies the second component of an OracleTimeStampLTZ

Value

Specifies the date and time that is stored in the OracleTimeStampLTZ structure

Year

Specifies the year component of an OracleTimeStampLTZ

OracleTimeStampLTZ Methods

The OracleTimeStampLTZ methods are listed in Table 14-119.

Table 14-119 OracleTimeStampLTZ 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 OracleTimeStampLTZ 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 OracleTimeStampLTZ instance (Overloaded)

GetHashCode

Returns a hash code for the OracleTimeStampLTZ instance

GetDaysBetween

Subtracts an OracleTimeStampLTZ from the current instance and returns an OracleIntervalDS that represents the difference

GetYearsBetween

Subtracts an OracleTimeStampLTZ from the current instance and returns an OracleIntervalYM that represents the difference

GetType

Inherited from System.Object

ToOracleDate

Converts the current OracleTimeStampLTZ structure to an OracleDate structure

ToOracleTimeStamp

Converts the current OracleTimeStampLTZ structure to an OracleTimeStamp structure

ToOracleTimeStampTZ

Converts the current OracleTimeStampLTZ structure to an OracleTimeStampTZ structure

ToString

Converts the current OracleTimeStampLTZ structure to a string

ToUniversalTime

Converts the current local time to Coordinated Universal Time (UTC)