Level 56
Order::whereRaw('date(created_at) = ?', [$date])->get();
Jul 2, 2015
6
Level 2
Using mysql DATE function inside query
Hi.
I have this query :
$pagination =Orders::where('created_at' ,'=' ,'2015-07-24 07:22:00')->paginate(11);
and it work fine, now I need a specific option,to check only date from timestamp.
Sql query will be :
SELECT * FROM orders WHERE date( created_at ) = '2015-07-24'
NOw, how to implement date( created_at ) in Laravel query ?
Tnx
Level 2
Yeah,this work,I try that,but is then posibility to use paggination ?
Level 56
Why wouldnt it be possible ?
Order::whereRaw('date(created_at) = ?', [$date])->paginate();
Level 2
I try just like you:
and get this error:
TokenMismatchException in compiled.php line 2440
Level 56
This is totally unrelated with the query
Level 2
Tnx for time! I will inform here whene solve problem,tnx again!
Please or to participate in this conversation.