MONTHS_BETWEEN

The MONTHS_BETWEEN function returns an numeric value of the number of months between the two input dates of the function.

Format: MONTHS_BETWEEN (datetime_expression1, datetime_expression2)

Example1:

Result: 48 (gives that there are 48 months in between the two dates).

Example2:

Result: -48 (the first date is a lower (earlier) date than the second date).

Example3:

Result: 32.8709677419355 (a non-integer result).

 

 

Leave a Reply

  • (will not be published)