List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 12 1999 11:50am
Subject:Re: Date-Function date_sub()
View as plain text  
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/
Thread
Date-Function date_sub()Gaetano Gallo12 May
  • Re: Date-Function date_sub()johan.engstrom12 May
  • Re: Date-Function date_sub()Gaetano Gallo12 May
  • Re: Date-Function date_sub()Paul DuBois12 May
  • Re: Date-Function date_sub()Jim Faucette12 May
  • Re: Date-Function date_sub()Fred Read12 May