Group by month producing error in laravel controller I am trying to execute mysql query SELECT COUNT( * ) FROM `Mytable` WHERE `col1` = 'value' GROUP BY MONTH(Date_time) Laravel statement for the same is : DB::table('Mytable')->where('col1','value')->GroupBy(MONTH('Date_time'))->count(); As query is fine but getting error : Call to undefined function App\Http\Controllers\MONTH() Any suggestion will be helpful Best answer : Instead of: ->GroupBy(MONTH('Date_time')) try ->groupBy(DB::raw("MONTH('Date_time')")) as MONTH() is a mysql function, not laravel function. source :http://stackoverflow.com/questions/41460359/group-by-month-producing-error-in-laravel-controller