格式化时间进行查询
Laravel框架查询:
$query_send = Send::select(DB::raw("FROM_UNIXTIME(UNIX_TIMESTAMP(created_at),'%Y-%m-%d') as riqi"))->groupBy(DB::raw("FROM_UNIXTIME(UNIX_TIMESTAMP(created_at),'%Y-%m-%d')"))->orderBy("riqi","desc")->take(10)->get();//take(10)获取最近10条
MySQL查询:
select FROM_UNIXTIME(UNIX_TIMESTAMP(created_at),'%Y-%m-%d') as riqi from `hx_send` group by FROM_UNIXTIME(UNIX_TIMESTAMP(created_at),'%Y-%m-%d') order by `riqi` desc limit 10
再按天查询每天数据