/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 vote208 views1 answer
Parent and child link in mysql
SQL
0 vote179 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
16 votes182 views2 answers
Oracle ddl
SQL
15 votes190 views5 answers
If null mysql
SQL
0 vote182 views1 answer
Sql select rows with different values in one column
SQL
0 vote188 views1 answer
Oracle concat datetime
SQL
0 vote173 views1 answer
Alter table name including schema
SQL
1 vote182 views1 answer
Return size of tables in mysql
SQL
0 vote185 views1 answer
Migrations.RunSQL
SQL
0 vote193 views1 answer
Mysql update all record removing 2 hours from column
SQL

Share