CODEWITHSUNDEEP
mysql
Matan Tubul
Matan Tubul

Reputation: 794

How to add seven days to DATE field

I would like to update each DATE field and add him 7 days. i check for DATE functions in php but i didn't found function that fit to MySQL syntax my query is:

$query_sched = "UPDATE events SET events.event_date = DATE(events.event_date + INTERVAL 7)";
$res = mysqli_query($dblink, $query_sched) or die (mysqli_error($dblink));

Upvotes: 0

Views: 206

Answers (1)

HashSu
HashSu

Reputation: 1517

You are missing a '+'

UPDATE events SET events.event_date = DATE(events.event_date + interval 7 day) WHERE events.event_id = '$event_id'



UPDATE events SET events.event_date = DATE_ADD(events.event_date , interval 7 day) WHERE events.event_id = '$event_id'

Output: 

update test set test.date = date(test.date + interval 7 day) where test.id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Upvotes: 1

Related Questions