MySQL Interval

• MySQL interval values are used mainly for date and time calculations.

INTERVAL {value of unit} {types of interval}

• INTERVAL is a MySQL keyword and this is case sensitive. This should be used in CAPITAL Later Only
• {value of unit} is a expression or value like 1,2,3,4 or any expression which result in value.
• {type of interval} is a MySQL date time unit and is described below. This show also be used in CAPITAL later only.

Type of Interval

Examples:

Query:

SELECT ‘2018-03-23’ + INTERVAL 1 DAY;

Result:

Posts to Review:

mysql query get date of 1 month interval mysql length function Rename table in MYSQL MySQL : Introduction to MySQL