phplaravellaravel-5.1

Laravel Select records in specific year

I'm new to Laravel and struggling to identify how I can select all records created in 2015 using the created_at field provided by the timestamp.

The model I am using is Blog: 

$posts = Blog::latest()->get();

Example date in database: 

2015-01-25 12:53:27

Could anyone shed some light?

Thanks!

Solution

  • You can do it like that: $posts = Blog::where( DB::raw('YEAR(created_at)'), '=', '2015' )->get();

    Here you can get year from created_at field with YEAR function, then compare with your date.