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
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]