Outdated Version
You are viewing an older version of this section. View current production version.
MONTHS_BETWEEN
Subtracts to find the number of months between two dates.
Syntax
MONTHS_BETWEEN(date1, date2)
Arguments
- date1, date2: a valid date, datetime, or parsable date string. Only the date part is used.
Return Type
Integer. If date1 or date2 is not a valid date, returns NULL.
Examples
select months_between(date('2017-03-01'), date('2017-01-01'));
+--------------------------------------------------------+
| months_between(date('2017-03-01'), date('2017-01-01')) |
+--------------------------------------------------------+
| 2 |
+--------------------------------------------------------+
1 row in set (0.06 sec)
If date1 is in the past, the function returns a negative result.
select months_between(date('2017-01-01'), date('2017-03-01'));
+--------------------------------------------------------+
| months_between(date('2017-01-01'), date('2017-03-01')) |
+--------------------------------------------------------+
| -2 |
+--------------------------------------------------------+
1 row in set (0.06 sec)
now() can be used as one of the parameters.
select months_between('2017-10-31',now());
+------------------------------------+
| months_between('2017-10-31',now()) |
+------------------------------------+
| 2.741935483870968 |
+------------------------------------+
1 row in set (0.06 sec)
Related Topics
