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