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.
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.