What MySQL returns if I use enclosed set of unit values with INTERVAL keyword?

In this case, MySQL will take into consideration the first value out of two provided in the enclosed set of unit values. It will return the output along with warning after calculating the interval, based on the considered value from an enclosed set, on the unit given in INTERVAL keyword. 

The following example will clarify it −

mysql> Select TIMESTAMP('2017-10-22 04:05:36' + INTERVAL '4 2' Hour)AS 'HOUR VALUE INCREASED BY 4';
+---------------------------+
| HOUR VALUE INCREASED BY 4 |
+---------------------------+
| 2017-10-22 08:05:36       |
+---------------------------+
1 row in set, 1 warning (0.00 sec)

mysql> Show warnings;
+---------+------+------------------------------------------+
| Level   | Code | Message                                  |
+---------+------+------------------------------------------+
| Warning | 1292 | Truncated incorrect INTEGER value: '4 2' |
+---------+------+------------------------------------------+
1 row in set (0.00 sec)

Vrundesha Joshi

Published on 19-Feb-2018 11:05:45

• Related Questions & Answers
• What MySQL returns if I write only one value in the enclosed set of unit values for compound INTERVAL unit?
• How can I use the arithmetic operators (+,-,*,/) with unit values of INTERVAL keyword in MySQL?
• How MySQL behaves if I use INTERVAL keyword with an invalid date?
• What are the different unit values that can be used with MySQL INTERVAL keyword?
• How can I use INTERVAL keyword with MySQL NOW() and CURDATE() functions?
• What MySQL returns if the first argument of INTERVAL() function is NULL?
• How to use compound INTERVAL unit in MySQL?
• How MySQL behaves when we use INTERVAL of time unit with CURDATE() function?
• How can I use MySQL INTERVAL keyword while extracting the part of the date?
• What MySQL returns if we use UNIX_TIMESTAMP() function with no argument?
• What MySQL returns if I insert invalid value into ENUM?
• What MySQL returns if sub-query, used to assign new values in the SET clause of UPDATE statement, returns no rows?
• What MySQL returns if sub-query, used to assign new values in the SET clause of UPDATE statement, returns multiple rows?
• What happens if I will use integer values as arguments of MySQL LOCATE() function?
• How can I use MySQL INTERVAL() function with a column of a table?