Craig Hibbert wrote:
SELECT FROM_UNIXTIME(time) FROM srvlog WHERE FROM_UNIXTIME(time >=
'1080948600') AND FROM_UNIXTIME(time <= '1080997876');
Why do you have FROM_UNIXTIME() in the WHERE clause? You said
the "time" column was already in Unix time, and regardless, you're
passing the function the
Hello,
I have been pulling my hair out trying to get a SELECT statement to work
using a range of Unix timestamps as the criteria.
MySQL Version 4.0
SELECT FROM_UNIXTIME(time) FROM srvlog WHERE FROM_UNIXTIME(time >=
'1080948600') AND FROM_UNIXTIME(time <= '1080997876');
I also tried