Interval ... week produces syntax error.

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

Re: Interval ... week produces syntax error.

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 week and

Re: Interval ... week produces syntax error.

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 it works.