Mysql(Laravel)实现按天分组查询数据 - DB::raw - FROM_UNIXTIME()- UNIX_TIMESTAMP()
格式化时间进行查询
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-%
原创
2017-12-07 17:59:12 ·
6981 阅读 ·
0 评论