Laravel4.2: Eloquent - Use DATE_FORMAT in SQL query

Question

I am trying this simple sql query

SELECT DATE_FORMAT(my_date, '%m-%d-%Y') FROM my_tbl WHERE id = 1

in Eloquent like

$tbl = DB::table('my_tbl');
$tbl->select( 'DATE_FORMAT(my_date, "%m-%d,-%Y")' );
$tbl->where( 'id', "=", 1);
Datatable::query($tbl);

but it accepts as string and throws error:

{"error":{"type":"Illuminate\\Database\\QueryException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'DATE_FORMAT(arrival, \"%d %M, %Y\")'

PHP Ferrari · Accepted Answer · 2015-03-03 12:33:32Z

1

Okay I just add DB::raw and it worked :)

$tbl->select( 'DB::raw('DATE_FORMAT(my_date, \'%m-%d-%Y\') AS arrival')' );

answered Mar 3, 2015 at 12:33

PHP Ferrari

15.7k27 gold badges87 silver badges152 bronze badges

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

Collectives™ on Stack Overflow

Laravel4.2: Eloquent - Use DATE_FORMAT in SQL query

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