Example: Querying for the Number of Months for One Date - Teradata Vantage

The following query:

SELECT MONTHS_BETWEEN(DATE'2008-09-25', DATE'2008-09-25');

returns the result 0.0 because date_timestamp_value1 and date_timestamp_value2 are the same date.