Get only records created today in laravel

mysql date activerecord where laravel-5.1
TheWebs picture TheWebs · Oct 21, 2015 · Viewed 109.8k times · Source

How do I use the created_at field to get only the records that were created today and no other day or time?

I was thinking of a ->where('created_at', '>=', Carbon::now()) But Im not sure that would work.

Answer

ashish picture ashish · Jun 18, 2018

for Laravel 5.6+ users, you can just do

    $posts = Post::whereDate('created_at', Carbon::today())->get();

Happy coding

Related questions

MySQL Query GROUP BY day / month / year

Is it possible to make a simple query to count how many records I have in a determined period of time like a year, month, or day, having a TIMESTAMP field, like: SELECT COUNT(id) FROM stats WHERE record_date.…

Read More
How to select date from datetime column?

I have a column of type "datetime" with values like 2009-10-20 10:00:00 I would like to extract date from datetime and write a query like: SELECT * FROM data WHERE datetime = '2009-10-20' ORDER BY datetime DESC Is the …

Read More
how to convert a string to date in mysql?

I have a string column which acts as a date and I want to select it as a date. Is it possible? My sample data format would be; month/day/year -> 12/31/2011

Read More