Page 1 of 1

datetime modification

Posted: Mon May 12, 2003 4:30 am
by Guy
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

Posted: Mon May 12, 2003 4:41 am
by twigletmac
You can use DATE_ADD():

Code: Select all

SELECT DATE_ADD('2003-05-12 19:00:00', INTERVAL 1 DAY)
or do

Code: Select all

SELECT '2003-05-12 19:00:00' + INTERVAL 1 DAY
Mac