- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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)
- Related Articles
- 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?
- How to add a number of months to a date using JavaScript?
- Add months to current date using Calendar.add() method in Java
- How can we add a time interval to date stored in a column of MySQL table?
- How can we provide a date with only year (zero months & zero days) value in MySQL?
- Select dates between current date and 3 months from the current date in MySQL?
- How to calculate the date three months prior using JavaScript?
- Java Program to add 3 months to the calendar
- Add a single day to datetime field with MySQL INTERVAL
- How Add or Subtract Specific Years, Months and Days to a Date in Excel?
- What are the different ways in MySQL to add ‘half year interval’ in date?
- How to Add the Number of Years Months and Days to a Date in Google Sheets?
- Add the following:7 years 8 months and 8 years 9 months
Advertisements