Value (OraIntervalDS)

Applies To

OraIntervalDS

Description

When read, Value provides a string representation of the value of the OraIntervalDS object using the format: [+/-]Day HH:MI:SSxFF. When set, Value accepts a Variant of type String, a numeric value, or an OraIntervalDS.

Arguments

[in] value

A Variant of type String, a numeric value, or an OraIntervalDS.

Usage

string = OraIntervalDSObj.Value

OraIntervalDSObj.Value = value

Datatype

Variant

Remarks

If the value set is a variant of type String, it must be in the following format: [+/-]Day HH:MI:SSxFF.

If the value set is a numeric value, the value provided should represent the total number of days that the OraIntervalDS represents.

Example

Dim oraIDS as OraIntervalDS

'Create an OraIntervalDS using a string which represents 1

'day and 12 hours

Set oraIDS = oo4oSession.CreateOraIntervalDS("1 12:0:0.0")

'get the OraIntervalDS.Value

'return a string for the Value property, idsStr is set

'to "01 12:00:00.000000"

idsStr = oraIDS.Value

'can also return a string for the Value property as follows

idsStr = oraIDS

'set the OraIntervalDS.Value using a string which represents

'1 days and 12 hours

oraIDS.Value = "1 12:0:0.0"

'set the OraIntervalDS.Value using a numeric value which represents

'1 days and 12 hours

oraIDS.Value = 1.5

Also see OraSession.CreateOraIntervalDS for more information.