/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

3 votes166 views1 answer
Ubuntu install postgresql 12
SQL
1 vote211 views1 answer
Mysql limit results to 10
SQL
1 vote254 views1 answer
Oracle check table lock
SQL
0 vote238 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote205 views1 answer
Normalization in database
SQL
3 votes220 views1 answer
Force using index oracle
SQL
0 vote203 views1 answer
Find number of entries sql
SQL
0 vote200 views1 answer
Oracle last character of string
SQL
9 votes223 views1 answer
Oracle get table schema
SQL
25 votes198 views1 answer
Mysql grant all privileges to a user
SQL

Share