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
datetime modification
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
You can use DATE_ADD():
or do
Mac
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