0

Adding Days To Dates In MySQL

One of my customers recently asked me to increment the date field on an event in their database by 30 days because their upcoming event got delayed. I knew the SQL statement would be simple and after doing some quick research, I found the magical SQL:

[code language=”css”]
UPDATE wp_em_events SET event_start_date = DATE_ADD(event_start_date,INTERVAL 30 DAY) WHERE event_id = 393
[/code]

Sandeep Kumar

Sandeep kumar is a web developer and a professinal blogger. He works for latest technologies and write articles what he learn. In ICodeHub he share web languages tutorials and other programming tips and tricks. if you need some help or have some suggestion then mail him at sandeep92pal@gmail.com without any hesitation. He believes in learning and sharing.