> Any ideas why this works in MySQL 5.0.18 and not in 3.23.53-log? > "SELECT StartDate + INTERVAL 1 MONTH from petition;" What if you try DATE_ADD? SELECT DATE_ADD(StartDate, INTERVAL 1 MONTH) AS one_month_later FROM [...] (s'funny, I'd never think to just use +. I've always used the date_add/date_sub functions.