如何从laravel 5.1中数据库表的created_at属性中选择年和月?
- 作者: 静静的顿河故事
- 来源: 51数据库
- 2022-10-21
问题描述
我的问题是我只想从 created_at 属性中获取数据库表中的数据，仅按年和月计算.我试过的代码是:
My problem is that I want to get data form the database table from the created_at attributes as per year and month only. The code I have tried is:
$post= M**log::select(DB::raw('YEAR(created_at) year, MONTH(created_at) month'));
$posts_by_y_m = $post->where('created_at',$post)->get();
推荐答案
查询构建器中有可用的日期助手:
There are date helpers available in the query builder:
$post = M**log::whereYear('created_at', '=', $year)
->whereMonth('created_at', '=', $month)
->get();
推荐阅读
