The following example uses the INTERVAL function:
SELECT INTERVAL(PERIOD(DATE '2016-02-29', DATE '2016-03-01')) MONTH ; INTERVAL(PERIOD(2016-02-29, 2016-03-01)) MONTH ---------------------------------------------- 1
The result is an INTERVAL value.
The following example uses the INTERVAL function:
SELECT INTERVAL(PERIOD(DATE '2016-02-29', DATE '2016-03-01')) MONTH ; INTERVAL(PERIOD(2016-02-29, 2016-03-01)) MONTH ---------------------------------------------- 1
The result is an INTERVAL value.