SELECT * from table where DATE(FROM_UNIXTIME(time))=DATE(NOW());

------解决方案--------------------

SQL code
SELECT * FROM table WHERE DATE(FROM_UNIXTIME(time))=CURDATE();

------解决方案--------------------
SQL code

SELECT * FROM table WHERE FROM_UNIXTIME(TIME, '%Y-%m-%d' ) =CURDATE();

------解决方案--------------------
以上写法均不推荐:

select * from `table` where `time` >= curdate()