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!
Just for completition. There is a Laravel method for it.
Blog::whereYear('created_at', 2017)->get();
See where clause, subsection whereDate / whereMonth / whereDay / whereYear
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With