Value (OraTimeStamp) Property

Applies To

OraTimeStamp Object

Description

When read, Value provides a string representation of the value of the OraTimeStamp 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 format (NLS_TIMESTAMP_FORMAT). When set, Value accepts a Variant of type String, Date, or OraTimeStamp.

Arguments

[in] value

A Variant of type String, Date, or OraTimeStamp.

Usage

string = OraTimeStampObj.Value

OraTimeStampObj.Value= value

Datatype

String

Remarks

If the value is of a type String and Format is not null, the string format must match the Format property. If Format is null, the string format must match the session TIMESTAMP format.

Example

...

Set OraTimeStamp = OraSession.CreateOraTimeStamp("1999-APR-29

     12:10:23.444 AM", "YYYY-MON-DD HH:MI:SS.FF AM")

'returns a string for the Value property

tsStr = OraTimeStamp.Value

'set OraTimeStamp.Value using a string

OraTimeStamp.Value = "1999-APR-29 12:10:23.444 AM"

Also see OraSession.CreateOraTimeStamp for more information.