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 DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]