/SQL/Date_add mysql

Date_add mysql

Date_add mysql

Syntax:
DATE_ADD(date, INTERVAL value addunit)

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

Output:
2020-11-22

1

Mysql add days to date

UPDATE classes 
SET `date` = DATE_ADD(`date`, INTERVAL 2 DAY)
WHERE id = 161

0

Source: stackoverflow.com

Mysql add days to date

UPDATE classes 
SET `date` = DATE_ADD(`date` , INTERVAL 2 DAY)
WHERE `id` = 161;

0

Source: stackoverflow.com

Similar codes

0 vote135 views1 answer
Display first three characters sql
SQL
0 vote123 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote148 views3 answers
Postgres date difference seconds
SQL
0 vote129 views1 answer
Parsing float to int in mysql
SQL
0 vote129 views2 answers
Start mysql server using docker
SQL
0 vote125 views1 answer
Set a default value for a column in sqlite
SQL
0 vote140 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
15 votes131 views1 answer
Mysql int range
SQL
0 vote174 views1 answer
Sql pivot table
SQL
0 vote133 views1 answer
Mysql create index lost connection
SQL

Share