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 "quarter" http://www.mysql.com/doc/en/Date_and_time_functions.html.
Can someone explain this? TIA
The manual says:
The values QUARTER and WEEK are allowed as of MySQL 5.0.0.
Paul,
Ok, thanks I see it now. It would have been nice if they put an "*" or "5.0.0" beside "WEEK" and "QUARTER" in the table so people would know it wasn't currently implemented in 4.x.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]