Eloquent where date methods

In Eloquent, check the date with functions whereDay(), whereMonth(), whereYear(), whereDate() and whereTime().

User::whereDate('created_at', today())->get();
User::whereMonth('created_at', '12')->get();
User::whereDay('created_at', '31')->get();
User::whereYear('created_at', date('Y'))->get();
User::whereTime('created_at', '=', '14:13:58')->get();

Keep in mind that those SQL functions will NOT use the database index on that created_at column, so the query may be slower than you expect.