如何从laravel 5.1中的数据库表的created_at属性中选择年和月? [英] How to select year and month from the created_at attributes of database table in laravel 5.1?
本文介绍了如何从laravel 5.1中的数据库表的created_at属性中选择年和月?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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();
解决方案
查询构建器中有可用的日期助手: / p>
$ post = Mjblog :: whereYear('created_at','=',$ year)
- > whereMonth ('created_at','=',$ month)
- > get();
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= Mjblog::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 = Mjblog::whereYear('created_at', '=', $year)
->whereMonth('created_at', '=', $month)
->get();
这篇关于如何从laravel 5.1中的数据库表的created_at属性中选择年和月?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文