Oracle® Objects for OLE Developer's Guide 11g Release 2 (11.2) for Microsoft Windows Part Number E17727-03 |
|
|
PDF · Mobi · ePub |
The OraIntervalYM
object provides methods for operations on the Oracle INTERVAL
YEAR
TO
MONTH
.This data type represents a period of time in terms of years and months.
The OraIntervalYM
object is created by the OraSession.CreateOraIntervalYM
method or by calling the Clone
method on an existing OraIntervalYM
object.
An OraIntervalYM
object can be bound using ServerType
ORATYPE_INTERVALYM
. This allows the binding of a value to a parameter associated with an Oracle INTERVAL
YEAR
TO
MONTH
data type in a SQL or PL/SQL statement.
When binding a string associated with an INTERVAL
YEAR
TO
MONTH
data type, the ServerType
must be specified to be a string type (for example, ORATYPE_VARCHAR2,
ORATYPE_STRING
), and the string must be in the format specified by YEARS-MONTHS.