Syntax Error or access violation - SQL query & Laravel

Question

In my query, i am trying to compare today's date only (without time) to my field created_at but i get the error below

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2018-08-29 DATE(created_at)' at line 1

Controller

$item_shipped =  Item::where('id',Auth::user()->id)->whereRaw('DATE(created_at)' , '=', Carbon::now()->toDateString())->get();

        return $item_shipped;

How do i solve this problem ?

Phiter · Accepted Answer · 2018-08-29 15:01:08Z

2

whereRaw doesn't accept the operator parameter. You have to write the whole condition and it takes the second parameter which is an array of bindings.

You need this:

->whereRaw('DATE(created_at) = ?', [Carbon::now()->toDateString()])->get();

answered Aug 29, 2018 at 15:01

Phiter

15k14 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error or access violation - SQL query & Laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related