[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...

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function_date-add

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 :)
Paul



More information about the thelist mailing list