At 10:11 AM +0100 5/12/1999, Gaetano Gallo wrote:
>Hi to all,
>
>we are using mysql release 3.21.29-gamma on FreeBSD 2.2.5.
>
>our problem is as follows:
>
>'select data_sub('1999-01-01', INTERVAL 1 HOUR);' or
>'select data_sub("1999-01-01", INTERVAL 1 HOUR);' or
>'select data_sub("1999-01-01", INTERVAL "1" HOUR);' or
>'select data_sub("1999-01-01 10:00:00", INTERVAL "1" HOUR);'
>
>each line results in the following error message:
>
>ERROR 1064: parse error near '("1999-01-01 10:00:00",INTERVAL "1" HOUR)'
>at line 1
>
>any help or information appreciated.
According to the change notes section of the manual, DATE_ADD() and
DATE_SUB() did not appear until version 3.22.4.
Your version of MySQL doesn't support these functions.
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
