Oracle® Objects for OLE Developer's Guide 11g Release 2 (11.2) for Microsoft Windows Part Number E12245-01 |
|
|
View PDF |
Applies To
Description
When read, the Value
property 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 the Format
property; otherwise, the output string format is in the session TIMESTAMP
WITH
TIME
ZONE
format (NLS_TIMESTAMP_TZ_FORMAT
). When set, the Value
property accepts a Variant
of type String
, Date
, or OraTimeStampTZ
.
Usage
string = OraTimeStampTZObj.ValueOraTimeStampObjTZ.Value= value
Arguments
Arguments | Description |
---|---|
[in ] value |
A Variant of type String , Date , or OraTimeStampTZ . |
Data Type
String
Remarks
If the Variant
is of type String
and the Format
property 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.
Examples
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"
See Also:
CreateOraTimeStampTZ Method