I can't get the following functions to work. Anyone know why?

select subtime(endtime,starttime) from huntlog

select substr(food,1,1) from huntlog

MySQL spits back

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( endtime , starttime ) from huntlog
LIMIT 0, 30' at line 1


It seems these functions don't want to work. Column names are valid. I've done selects on them, but the functions don't work. I can do

select count(*) from huntlog

Any help is appreciated.

Thanks.

The most obvious question is what version of mysql are you using?

From the mysql manual -

Here's the funny part (probably should've mentioned this earlier). I'm running 5.0.12 on my machine, but connect to a work server that's running an earlier version (3.XX) I believe. I'm going to assume 5.0.12 is getting confused somehow and referencing an .ini or .dll for the earlier version.