In Eloquent, check the date with functions whereDay(), whereMonth(), whereYear(), whereDate() and whereTime().
// check date
Post::whereDate('created_at', '2020-01-31')->get();
// check month
Post::whereMonth('created_at', '12')->get();
//check day
Post::whereDay('created_at', '31')->get();
// check year
Post::whereYear('created_at', date('Y'))->get();
// check time
Post::whereTime('created_at', '=', '14:13:58')->get();
