OraIntervalDS Object

Description

The OraIntervalDS object provides methods for operations on the Oracle INTERVAL DAY TO SECOND.This data type represents a period of time in terms of days, hours, minutes, seconds, and nanoseconds.

Remarks

The OraIntervalDS object is created by the OraSession.CreateOraIntervalDS method or by calling the Clone method on an existing OraIntervalDS object.

An OraIntervalDS object can be bound using the ServerType ORATYPE_INTERVALDS. This allows the binding of a value to a parameter associated with an Oracle INTERVAL DAY TO SECOND data type in a SQL or PL/SQL statement.

When binding a string associated with an INTERVAL DAY TO SECOND 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 Day HH:MI:SSxFF.

Properties

• Days Property

• Hours Property

• Minutes Property

• Nanonseconds Property

• Seconds Property

• TotalDays Property

• Value (OraIntervalDS) Property

Methods

• Add (OraIntervalDS) Method

• Clone (OraIntervalDS) Method

• Div (OraIntervalDS) Method

• IsEqual (OraIntervalDS) Method

• IsGreater (OraIntervalDS) Method

• IsLess (OraIntervalDS) Method

• Mul (OraIntervalDS) Method

• Neg (OraIntervalDS) Method

• Sub (OraIntervalDS) Method

• ToOraNumber (OraIntervalDS) Method