Mysql 常用的时间查询(周,月,季,年)
一 查询当日数据1 select * from v2_goods_base_price as v2 where date(v2.created_at) = curdate();2 select * from v2_goods_base_price as v2where year(v2.created_at)=year(now()) and month(v2.created_at)=month(n