mysql,查询语句需求时间等于当前时间
select * from enter_storehouse where remove=0 and
DATE_FORMAT( create_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' )
order by id desc
mysql,查询语句需求时间等于当前时间
select * from enter_storehouse where remove=0 and
DATE_FORMAT( create_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' )
order by id desc