Re: Date-Function date_sub()

[Fred Read]

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.