MONTHS_BETWEEN_UDF
Definition
Reproduce the MONTHS_BETWEEN functionality
MONTHS_BETWEEN_UDF(FIRST_DATE TIMESTAMP_LTZ, SECOND_DATE TIMESTAMP_LTZ)Parameters
FIRST_DATE TIMESTAMP_LTZ
The first or starting date to be processed in the function.
SECOND_DATE TIMESTAMP_LTZ
The second or ending date that determines the end of the count.
Returns
The number of months between the first and the second date.
Usage example
Input:
SELECT MONTHS_BETWEEN_UDF('2022-02-14', '2021-02-14');Output:
12Last updated