Laravel Date Filtering

I would like to talk about the date filtering process I am using in laravel today.

If we want to select records that is created today. We can normally use raw queries or without raw queries like this.

//Raw Query
Model::where(DB::raw("DATE(created_at) = '".date('Y-m-d')."'"))->get();

//Not Raw Query
Model::where('created_at', '>=', date('Y-m-d').' 00:00:00'))->get();

In fact, we can do more neat and eloquent way in laravel like this.

Model::whereDate('created_at', '=', date('Y-m-d'))->get();

We can also use Carbon function instead of date(), result will still the same.

Model::whereDate('created_at', '=', Carbon::today()->toDateString())->get();

If you want to filter just not with full date, it’s totally fine. You can filter with day, month and year like this.

//Day
Model::whereDay('created_at', '=', date('d'))->get();
//Month
Model::whereMonth('created_at', '=', date('m'))->get();
//Year
Model::whereYear('created_at', '=', date('Y'))->get();

There is also another method called `whereBetween` if you want to filter by date range.

Model::whereBetween('created_at', [FROM_DATE, TO_DATE])->get();

By Yuuma

このエントリーをはてなブックマークに追加


yuuma at 2021年02月22日 11:00:59


アプリ関連ニュース

お問い合わせはこちら

お問い合わせ・ご相談はお電話、またはお問い合わせフォームよりお受け付けいたしております。

tel. 06-6454-8833（平日 10:00～17:00）

お問い合わせフォーム


↑

↓