datetime modification

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Guy
Forum Commoner
Posts: 53
Joined: Sun Jan 12, 2003 3:34 am

datetime modification

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply