[thelist] [MySQL] date_add

Paul Bennett Paul.Bennett at wcc.govt.nz
Wed May 23 19:32:13 CDT 2007

Hi all,

Any ideas why this works in MySQL 5.0.18 and not in 3.23.53-log?

"SELECT StartDate + INTERVAL 1 MONTH from petition;"

The manual implies* that this completely possible in MySQL 3.23.x...


Weird thing is that MySQL 3.23 lets me run the query like this:

"SELECT CURRENT_DATE + INTERVAL 1 MONTH as one_month_later;"
But this fails:
"SELECT CURRENT_DATE + INTERVAL 1 MONTH as one_month_later from petition;" 

Any ideas welcomed - I'm quickly running out :)

More information about the thelist mailing list