- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
Updated on 29-Jan-2020 06:35:05
- Related Questions & Answers
- Add some months to current date using Java with MySQL?
- 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?
- 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?
- 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
- How can it be possible to invert a string in MySQL?
- Java Program to subtract months from current date using Calendar.add() method
- How can I use MySQL INTERVAL keyword while extracting the part of the date?
Advertisements