DAYS_BETWEEN
The DAYS_BETWEEN function returns the number of days between two dates, excluding the two dates themselves. If the later date is first, the result is a positive number. If the earlier date is first, the result is a negative number.
The result is a NUMERIC data type.
Syntax
DAYS_BETWEEN (end-date, start-date)
Example
DAYS_BETWEEN ('1995-01-01', '1995-01-10')
This example returns a result of -9, because date1 is earlier than date2.