Wednesday, February 24, 2010

mysql - adding one year quickly

I don't want to forget how to add one year (or any interval) so I'm making a note.

DATE_ADD functions in MySQL always seem to get me since Sybase seems so different (but probably isn't that much). Plus, I was being very smart and keep trying to put a + instead of a ,. Silly Rabbit!

Here it is: SELECT DATE_ADD(NOW(),INTERVAL 1 YEAR)

An update to set expiration date 1 year into the future:

UPDATE mytable SET exp_timestamp = DATE_ADD(NOW(), INTERVAL 1 YEAR)

No comments:

Post a Comment