OraTimeStampTZ Object

Description

The OraTimeStampTZ object represents an Oracle TIMESTAMP WITH TIME ZONE data type and provides methods for operations on this Oracle data type. The OraTimeStampTZ represents a date-time value in a specific time zone that stores the following information: year, day, hour, minute, second, nanosecond, and the time zone.

Remarks

The OraTimeStampTZ object is created by the OraSession.OraCreateTimeStampTZ method or by calling the Clone method on an existing OraTimeStampTZ object.

An OraTimeStampTZ object can be bound using ServerType ORATYPE_TIMESTAMPTZ. This allows the binding of a value to a parameter associated with an Oracle TIMESTAMP WITH TIME ZONE data type in a SQL or PL/SQL statement.

When binding a string associated with an TIMESTAMP WITH TIME ZONE data type, the ServerType must be specified to be a string type (for example, ORATYPE_VARCHAR2, ORATYPE_STRING) and the string must be in the format specified by NLS_TIMESTAMP_TZ_FORMAT.

Properties

• Day (OraTimeStampTZ) Property

• Format (OraTimeStampTZ) Property

• Hour (OraTimeStampTZ) Property

• Minute (OraTimeStampTZ) Property

• Month (OraTimeStampTZ) Property

• Nanonsecond (OraTimeStampTZ) Property

• Second (OraTimeStampTZ) Property

• TimeZone (OraTimeStampTZ) Property

• Value (OraTimeStampTZ) Property

• Year (OraTimeStampTZ) Property

Methods

• AddIntervalDS Method

• AddIntervalYM Method

• Clone (OraTimeStampTZ) Method

• IsEqual (OraTimeStampTZ) Method

• IsGreater (OraTimeStampTZ) Method

• IsLess (OraTimeStampTZ) Method

• ToDate Method

• ToOraTimeStamp Method

• ToOraTimeStampLTZ Method

• ToUniversalTime Method