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