Re: "Interval ... week" produces syntax error.

2004-01-22 Thread mos
At 01:20 PM 1/22/2004, Paul DuBois wrote: At 10:49 -0600 1/22/04, mos wrote: I'm using MySQL 4.1.1 for NT and noticed the following select date_sub('2003-08-29', interval 21 week) produces a syntax error. It doesn't recognize "week" or "quarter". But I can substitute "day", "month", "year" and i

Re: "Interval ... week" produces syntax error.

2004-01-22 Thread Paul DuBois
At 10:49 -0600 1/22/04, mos wrote: I'm using MySQL 4.1.1 for NT and noticed the following select date_sub('2003-08-29', interval 21 week) produces a syntax error. It doesn't recognize "week" or "quarter". But I can substitute "day", "month", "year" and it works. The MySQL manual says it accepts

"Interval ... week" produces syntax error.

2004-01-22 Thread mos
I'm using MySQL 4.1.1 for NT and noticed the following select date_sub('2003-08-29', interval 21 week) produces a syntax error. It doesn't recognize "week" or "quarter". But I can substitute "day", "month", "year" and it works. The MySQL manual says it accepts "week" and "quarter" http://www.m