INTERVAL_CMP function

INTERVAL_CMP compares two intervals and returns 1 if the first interval is greater, -1 if the second interval is greater, and 0 if the intervals are equal. For more information, see Examples of interval literals without qualifier syntax.

Syntax

INTERVAL_CMP(interval1, interval2)

Arguments

Return type

INTEGER

Examples

The following example compares the value of 3 days to 1 year.

select interval_cmp('3 days','1 year');

interval_cmp
--------------
-1

This example compares the value 7 days to 1 week.

select interval_cmp('7 days','1 week');

interval_cmp
--------------
0

The following example compares the value of 1 year to 3 days.

select interval_cmp('1 year','3 days');

interval_cmp
--------------
1