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

The following query:

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

returns the result 0.0 since date_timestamp_value1 and date_timestamp_value2 are both the same date.