adding a day to an SQL date field

[gerkintrigg]

I've tried using the following code to add a day to the current date value:

 

SELECT (
start_date +1
), start_date
FROM `booking`
WHERE 1
LIMIT 0 , 30

 

but it's just returning the numbers with a 1 added to it... so "dates" like 20070332

 

Can anyone suggest how to change this to a real date?

[Wildbug]

Try the DATE_ADD() function.

 

SELECT DATE_ADD(start_date, INTERVAL 1 DAY), start_date FROM booking WHERE 1 LIMIT 0,30;

...or even:

SELECT start_date + INTERVAL 1 DAY,start_date FROM booking WHERE 1 LIMIT 0,30;