[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