![]() Previous |
![]() Next |
An interval expression yields a value of DSNTERVAL
or MYINTERVAL
where the expression has the following syntax.
interval_value_expr DAY [(leading_field_precision)] TO
SECOND [(fractional_second_precision)]| YEAR [(leading_field_precision)] TO MONTH
The interval_value_expr
can be a DSNTERVAL
or MYINTERVAL
value or a compound expression that yields a DSNTERVAL
or MYINTERVAL
value. Datetimes and intervals can be combined according to the rules defined in Table: Datetime Fields and Values . The six combinations that yield interval values are valid in an interval expression.
Both leading_field_precision
and fractional_second_precision
can be any integer from 0 to 9. If you omit the leading_field_precision
for either DAY
or YEAR
, then Oracle Database uses the default value of 2. If you omit the fractional_second_precision
for second, then the Database uses the default value of 6. If the value returned by a query contains more digits that the default precision, then Oracle Database returns an error. Therefore, it is good practice to specify a precision that you know is at least as large as any value returned by the query.