List:General Discussion« Previous MessageNext Message »
From:Johan Engström Date:May 12 1999 8:17am
Subject:Re: Date-Function date_sub()
View as plain text  
Hello Gaetano!

GG>'select data_sub('1999-01-01', INTERVAL 1 HOUR);'    or
GG>'select data_sub("1999-01-01", INTERVAL 1 HOUR);'  or
GG>'select data_sub("1999-01-01", INTERVAL "1" HOUR);'  or
GG>'select data_sub("1999-01-01 10:00:00", INTERVAL "1" HOUR);' 
GG>
GG>each line results in the following error message:
GG>
GG>ERROR 1064: parse error near '("1999-01-01 10:00:00",
GG>INTERVAL "1" HOUR)' at line 1

The function is DATE_SUB, not DATA_SUB. And if that does
not help, you have an older version of MySQL that does not yet
support the DATE_SUB-function.

Regards,

Johan

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