sql时间函数

select count(*) from mba_announcement_page where FROM_UNIXTIME(time,'%Y') = DATE_FORMAT(NOW(), '%Y') and (auth='{$batchid}' or auth='' or auth = '-1')
原文地址:https://www.cnblogs.com/zhangxiangdong/p/9829113.html