Datetime and Interval Datatypes

With Release 9.2.0.4, OO4O provides four new objects that enable developers to access and manipulate the new datetime and interval datatypes introduced in Oracle9i&nbsp. The OO4O objects and matching datatypes are:

OO4O Objects	Oracle Datatypes
OraIntervalDS	INTERVAL DAY TO SECOND
OraIntervalYM	INTERVAL YEAR TO MONTH
OraTimeStamp	TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE
OraTimeStampTZ	TIMESTAMP WITH TIME ZONE

Instances of these types can be fetched from the database or passed as input or output variables to SQL statements and PL/SQL blocks, including stored procedures and functions.

These new datatypes are not supported as elements in collections such as PL/SQL Indexed Tables, VARRAYs, or Nested Tables.

Obtaining Datetime and Interval Datatypes

These OO4O objects can be obtained using:

· The Value property of an OraField object in a Dynaset

· The Value property of an OraParameter object as an input or an output parameter in SQL Statements or PL/SQL blocks

· An Attribute of another object or REF

· The CreateOraIntervalDS, CreateOraIntervalYM, CreateOraTimeStamp, or CreateOraTimeStampTZ methods of the OraSession object

Descriptions of Datetime and Interval Datatypes

The OraTimeStamp object provides methods for operations on Oracle TIMESTAMP or TIMESTAMP WITH LOCAL TIME ZONE datatypes. These methods provide the ability to access the datetime values and to perform datetime operations.

The OraTimeStampTZ object provides methods for operations on Oracle TIMESTAMP WITH TIME ZONE data types. These methods provide the ability to access the datetime and time zone values, and to perform datetime operations.

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