Adding Days to Dates in MySQL

Posted . Visible to the public.

To quickly add a day or days to a timestamp field in mysql, you can run a query like this:
UPDATE events SET date_starts = DATE_ADD(date_starts,INTERVAL 14 DAY) WHERE event_id = 3;

Matt Tew
Last edit
Tags
Posted by Matt Tew to Matt Tew's deck (2012-03-22 20:35)