SQL - 选择unixtimestamp作为日期

Question

I am trying to select an unixtimestamp column from my database, as readable date time:

SELECT count(*) FROM users WHERE user_by="Admin" AND expire(FROM_UNIXTIME(unixtime),'%Y-%m-%d')='2015-10-02'

Above gives me this error:

#1305 - FUNCTION database_maindb.expire does not exist

How can I select the unixtimestamp from column expire as datetime, in the format: year-month-date?

Answer 1

assuming your database field is called "expire":

SELECT count(*) FROM users WHERE user_by="Admin" AND FROM_UNIXTIME(expire,'%Y-%m-%d')='2015-10-02'

see http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime for details