sql时间函数

select count(*) from mba_announcement_page where FROM_UNIXTIME(time,'%Y') = DATE_FORMAT(NOW(), '%Y') and (auth='{$batchid}' or auth='' or auth = '-1')
posted on 2018-10-22 11:20  _zxd  阅读(103)  评论(0编辑  收藏  举报