List:General Discussion« Previous MessageNext Message »
From:Fred Read Date:May 12 1999 1:24pm
Subject:Re: Date-Function date_sub()
View as plain text  
Gaetano Gallo wrote:
> 'select date_sub("1999-01-01 10:00:00", INTERVAL "1" HOUR);'
> still results in the error message:
> ERROR 1064: parse error near '("1999-01-01 10:00:00", INTERVAL "1"
> HOUR)' at line 1

What version of mysql are you running? 

The date_sub function wasn't added to MySQL until version 
3.22.4 so you will have to upgrade to a newer version if 
yours is older than that.

If it ain't opinionated, it ain't Rich Teer.
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