首页 ❯

如何从 laravel 5.1 中数据库表的created_at属性中选择年份和月份？

php laravel sql eloquent laravel-5.1
2022-08-30 17:57:04

我的问题是，我想从属性中获取数据，仅按年和月。我尝试过的代码是：created_at

$post= Mjblog::select(DB::raw('YEAR(created_at) year, MONTH(created_at) month'));
$posts_by_y_m = $post->where('created_at',$post)->get();

答案 1

查询生成器中提供了日期帮助程序：

$post = Mjblog::whereYear('created_at', '=', $year)
              ->whereMonth('created_at', '=', $month)
              ->get();

答案 2

如果要从单个实例中获取年和月，可以按如下方式访问它们：Mjblog

$year = $post->created_at->year;
$month = $post->created_at->month;

阅读有关 getters 文档的更多信息。Carbon\Carbon


推荐
更多 »
标签
更多 »
php pass-by-reference optional-parameters default-value javascript arrays dom function string object serialization tostring visibility syntax jslint use-strict operators equality equality-operator identity-operator datetime timestamp date-arithmetic redirect angularjs loops foreach iteration scope variables
推荐
更多 »