Add 3 Months Interval to MySQL Date Without Using the Word Months



It 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)
Updated on: 2020-01-29T06:35:05+05:30

364 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements