RE: Adding 1 day to date/datetime/timestamp?

["John W. Holmes" <holmes072000@charter.net>]

> I need to add one day to a datetime/date/timestamp field.  How would I
> do this?  (sorry for the n00b-ish question...)  I'm using mysql.

SELECT your_column + INTERVAL 1 DAY FROM your_table;

---John Holmes...



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php