datetime modification
Posted: Mon May 12, 2003 4:30 am
how can I add a day to datetime field in mysql?
like 2003-05-12 19:00:00 => 2003-05-13 19:00:00
Thanks
Guy
like 2003-05-12 19:00:00 => 2003-05-13 19:00:00
Thanks
Guy
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
SELECT DATE_ADD('2003-05-12 19:00:00', INTERVAL 1 DAY)Code: Select all
SELECT '2003-05-12 19:00:00' + INTERVAL 1 DAY