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
