Monday, February 20, 2012

MySQL Adding Dates

Talk about way easy to add to a date using MySQL. Didn't know it would be this simple:



Let's say you want to add a certain number of years to a date:




DATE_ADD(NOW(), INTERVAL 1 YEAR)


Now, wasn't that easy?



You can do the same thing for days as well. Just change INTERVAL 1 YEAR to INTERVAL 1 DAY



Yep, that's pretty much it.



Happy coding!

No comments:

Post a Comment

We Live In A Simulation

 You read that title right. We live in a simulation. Nothing is real. It's as real as you want it to be. But that doesn't mean it...