Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Value (OraTimeStampTZ) Property

Applies To

OraTimeStampTZ Object

Description

When read, Value provides a string representation of the value of the OraTimeStampTZ object. If the Format property is not null, the output string format is in the format specified by Format; otherwise, the output string format is in the session TIMESTAMP WITH TIME ZONE format (NLS_TIMESTAMP_TZ_FORMAT). When set, Value accepts a Variant of type String, Date, or OraTimeStampTZ.

Arguments

[in] value
A Variant of type String, Date, or OraTimeStampTZ.

Usage

string = OraTimeStampTZObj.Value

OraTimeStampObjTZ.Value= value

Datatype

String

Remarks

If the Variant is of type String and Format is not null, the string format must match the Format property. If the Format property is null, the string format must match the session TIMESTAMP WITH TIME ZONE format.

If the Variant is of type Date, the date time value in Date is interpreted as the date time value in the session time zone. The time zone information in the OraTimeStampTZ object contains the session time zone.

Example

Dim OraTimeStampTZ As OraTimeStampTZ

...

Set OraTimeStampTZ = OraSession.CreateOraTimeStampTZ("2003-APR-29

      12:00:00 -07:00", "YYYY-MON-DD HH:MI:SS TZH:TZM")

'returns a string for the Value property

tstzStr = OraTimeStampTZ.Value

...

'set OraTimeStampTZ.Value using a string

OraTimeStampTZ.Value = "2003-APR-29 12:00:00 -07:00"

Also see OraSession.CreateOraTimeStampTZ for more information.