mysql 获取今天新增数据

//查询今天新增数据

select * from d_wx_money_log where date(createtime) = curdate();

createtime 是数据库字段名 

//查询本周新增数据

select * FROM d_wx_member WHERE YEARWEEK(date_format(createtime,'%Y-%m-%d')) = YEARWEEK(now());