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 result of a logical operator (which evaluates
to 0 or 1) rather than a timestamp anyway. It appears that what you
want is
SELECT FROM_UNIXTIME(time) FROM srvlog WHERE time >=
1080948600 AND time <= 1080997876;
or (a shorter alternative)
SELECT FROM_UNIXTIME(time) FROM srvlog WHERE time BETWEEN
1080948600 AND 1080997876;
--
Keith Ivey <[EMAIL PROTECTED]>
Washington, DC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
