[thelist] [MySQL] date_add

Hassan Schroeder hassan.schroeder at gmail.com
Wed May 23 20:52:08 CDT 2007


well, rats. Nothing in that table description looks strange.

So this doesn't work --
"SELECT StartDate + INTERVAL 1 MONTH from petition;"

(but `doesn't work` as in, what error message?)

Does this work:   "SELECT StartDate from petition;"?

Does this explicitly grouped version fail the same way:
"SELECT (StartDate + INTERVAL 1 MONTH) as one_month_later from petition;"

Is the failure different if StartDate is populated versus being zero?

More questions than answers, I'm afraid.

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



More information about the thelist mailing list