mysql,查询语句需求时间等于当前时间
select * from enter_storehouse where remove=0 and
DATE_FORMAT( create_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' )
order by id desc
版权声明:本文为weixin_48616345原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。
mysql,查询语句需求时间等于当前时间
select * from enter_storehouse where remove=0 and
DATE_FORMAT( create_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' )
order by id desc