mysql搜索当天的记录

select *,FROM_UNIXTIME(trade_date) as dateeeeee from zm_trade where date_format(from_unixtime(trade_date),'%Y-%m-%d') = date_format(now(),'%Y-%m-%d');