Re: Date-Function date_sub()

[Jim Faucette]

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