MySQL add days to a date

Question

I have a table in MySQL  What would be the sql statement look like to add say 2 days to the current date value in the table   UPDATE classes  SET  date   date   1 where id   161   this adds one second to the value  i don t want to update the time  i want to add two days

User · Answer

For your need   UPDATE classes  SET  date    DATE ADD  date   INTERVAL 2 DAY  WHERE id   161

User · Answer

update tablename set coldate DATE ADD coldate  INTERVAL 2 DAY

User · Answer

SELECT DATE ADD CURDATE    INTERVAL 2 DAY

User · Answer

UPDATE table SET nameofdatefield   ADDDATE nameofdatefield  2  WHERE

User · Answer

You can leave date add function   UPDATE  table   SET  yourdatefield     yourdatefield    INTERVAL 2 DAY WHERE

User · Answer

DATE ADD FROM DATE HERE  INTERVAL INTERVAL TIME HERE DAY     will give the Date after adjusting the INTERVAL  eg   DATE ADD NOW    INTERVAL -1 DAY  for deducting 1 DAY from current Day DATE ADD NOW    INTERVAL 2 DAY   for adding 2 Days   You can use like  UPDATE classes WHERE date  DATE ADD date  INTERVAL 1 DAY   WHERE id 161

User · Answer

This query stands good for fetching the values between current date and its next 3 dates  SELECT   FROM tableName WHERE columName BETWEEN CURDATE   AND DATE ADD CURDATE    INTERVAL 3 DAY    This will eventually add extra 3 days of buffer to the current date

User · Answer

SET date   DATE ADD  fieldname  INTERVAL 2 DAY

User · Answer

Assuming your field is a date type  or similar    SELECT DATE ADD  your field name   INTERVAL 2 DAY   FROM  table name     With the example you ve provided it could look like this   UPDATE classes  SET  date    DATE ADD  date    INTERVAL 2 DAY  WHERE  id    161    This approach works with datetime   too

[mysql] MySQL add days to a date

Examples related to mysql

Examples related to sql