Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
MONTHS_BETWEEN
On this page
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.
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
Last modified: May 31, 2023