[thelist] [MySQL] date_add

[Hassan Schroeder]

On 5/23/07, Paul Bennett <Paul.Bennett at wcc.govt.nz> wrote:

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

3.23.53??  Uh, because you haven't sacrificed a chicken to placate the
restless spirits of the undead? That's WAG #1.  :-)

> "SELECT StartDate + INTERVAL 1 MONTH from petition;"

WAG #2 -- are your sure StartDate is a date or datetime, not a
timestamp?

> 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;"

yeah, that's wierd, and makes my #2 unlikely. Could it be permissions
on the table? And can you show the CREATE TABLE for 'petition'?

That can wait 'til you get back from the poultry market, though.

-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com