Value (OraIntervalYM)

Applies To

OraIntervalYM

Description

When read, Value provides a string representation of the value of the OraIntervalYM object using the format: [+/-]YEARS-MONTHS.

When set, Value accepts a Variant of type String, a numeric value, or an OraIntervalYM.

Arguments

[in] value

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

Usage

string = OraIntervalYMObj.Value

OraIntervalYMObj.Value= value

Datatype

String

Remarks

If the value set is a Variant of type String, it must be in following format: [+/-]YEARS-MONTHS.

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

Example

Dim oraIYM as OraIntervalYM

'Create an OraIntervalYM using a string which represents

'1 year and 6 months

Set oraIYM = oo4oSession.CreateOraIntervalYM("1-6")

'Add an interval using a string, which represents 2 years

'and 6 months, to oraIYM.

'The resulting oraIYM is an interval which represents 4 years

oraIYM.Add("2-6")

Also see OraSession.CreateOraIntervalYM for more information.