How can it be possible to add 3 months interval in a MySQL date without using the word ‘Months’ with interval?

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)

Nishtha Thakur

Published on 19-Feb-2018 10:39:10

• Related Questions & Answers
• Add some months to current date using Java with MySQL?
• What are the different ways in MySQL to add ‘half year interval’ in date?
• MySQL query to get records after an interval of 8 months
• How to add months to a date in JavaScript?
• Java Program to add 3 months to the calendar
• How to add a number of months to a date using JavaScript?
• Add months to current date using Calendar.add() method in Java
• Select dates between current date and 3 months from the current date in MySQL?
• How can we add a time interval to date stored in a column of MySQL table?
• Add a single day to datetime field with MySQL INTERVAL
• Fetch records from interval of past 3 days from current date in MySQL and add the corresponding records
• Order by last 3 months first, then alphabetically in MySQL?
• How can we provide a date with only year (zero months & zero days) value in MySQL?
• What are the different unit values that can be used with MySQL INTERVAL keyword?
• How can I use MySQL INTERVAL keyword while extracting the part of the date?