Answers for "date_add() in mysql"

SQL
0

mysql add days to date

UPDATE classes 
SET `date` = DATE_ADD(`date`, INTERVAL 2 DAY)
WHERE id = 161
Posted by: Guest on September-02-2020
1

date_add mysql

Syntax:
DATE_ADD(date, INTERVAL value addunit)

Example:
SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);

Output:
2020-11-22
Posted by: Guest on September-21-2021
0

mysql add days to date

UPDATE classes 
SET `date` = DATE_ADD(`date` , INTERVAL 2 DAY)
WHERE `id` = 161;
Posted by: Guest on September-02-2020
0

date_add mysql

SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);

Output:
2020-11-22
Posted by: Guest on September-21-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language