change default date format in laravel Raw sql query

I want to return date as DD/MM/YYY format in following query. I tries something but didn't work please advice


                ->select('time_sheets.progress',DATE_FORMAT('time_sheets.date', "%d/%l/%Y") ,'role_users.role_id','roles.role_name')

Best Answer

Level 88

You need to use the raw function to do that, something like this should work

->selectRaw("time_sheets.progress, DATE_FORMAT('time_sheets.date', '%d/%l/%Y') as date, role_users.role_id, roles.role_name")

1 like

Please or to participate in this conversation.