Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer Oracle Migration overview.

Ispirer SQLWays Database Migration Software

INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND

INTERVAL YEAR[(p)] TO MONTH

The INTERVAL YEAR TO MONTH data type stores a period of time represented as years and months.

p is the number of digits in the YEAR datetime field. The range of p is 0 to 9. The default value is 2.

This data type is available in Oracle 9i Release 1 (9.0.1) or later.

INTERVAL DAY[(p1)] TO SECOND[(p2)]

The INTERVAL DAY TO SECOND data type stores a period of time represented as days, hours, minutes and seconds with a fractional part.

p1 is the number of digits in the DAY datetime field. The range of p1 is 0 to 9. The default value is 2.

p2 is the number of digits in the fractional part of the SECOND datetime field. The range of p2 is 0 to 9. The default value is 6.

This data type is available in Oracle 9i Release 1 (9.0.1) or later.