MySQL 如何添加3个月的间隔而不使用单词“Months”和“Interval”
利用关键字Quarter,可以进行如下操作:
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)
阅读更多:MySQL 教程