List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:May 12 1999 1:15pm
Subject:Re: Date-Function date_sub()
View as plain text  
Gaetano Gallo wrote:
> 
> Sorry, i´ve just typed the wrong char
> 
> i mean
> 
> '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
> 

Is there a space between date_sub and the (? If so, that's your problem!

  jim...
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