Finds the difference between the ending and beginning bounds of a Period expression or a derived period and returns the difference as the duration of the argument in a specified interval qualifier.
Syntax
INTERVAL ( { period_expression | derived_period } ) interval_qualifier
- period_expression
- The Period expression to be converted.
- derived_period
- Any expression that evaluates to a Period data type.
- interval_qualifier
-
Any interval qualifier appropriate for the argument's element type. The interval qualifiers are as follows:
- Year-Month intervals:
- YEAR
- YEAR TO MONTH
- MONTH
- Day-Time intervals:
- DAY
- DAY TO HOUR, MINUTE or SECOND
- HOUR
- HOUR TO MINUTE or SECOND
- MINUTE
- MINUTE to SECOND
- SECOND
- Year-Month intervals: