How to add a 3 month gap in a MySQL date without using the word "month" with the gap?

is possible with the help of keyword Quarter as follows -

mysql> Select '2017-06-20' + INTERVAL 1 Quarter AS 'After 3 Months Interval';

+-------------------------+
| After 3 Months Interval |
+-------------------------+
| 2017-09-20              |
+-------------------------+
1 row in set (0.00 sec)

The above is the detailed content of How to add a 3 month gap in a MySQL date without using the word "month" with the gap?. For more information, please follow other related articles on the PHP Chinese website!