Laravel 5, DB :: raw, date format?

Navigation
-1
DB::raw("(SELECT TO_CHAR(CT_CONTRATO_SERVICIO_ESTADO.D_FECHA,'dd/mm/yyyy')
                FROM ct_contrato_servicio_estado
                WHERE N_ID_CONTRATO_SERVICIO = ct_contrato_servicio.n_id
                ORDER BY  CT_CONTRATO_SERVICIO_ESTADO.D_FECHA  DESC FETCH FIRST 1 ROW ONLY) fecha

I have the following code to obtain a date in format: dd/mm/yy but it returns me in: 03\/12\/1986 , what is the problem? Thanks

    
asked by joselo 04.06.2018 в 18:28
source

1 answer

0

The solution is the following, as I use postman, I had to mark in the option that is in blue and not the one in red:

I hope you serve other people

    
answered by 04.06.2018 в 19:59
Problem with Bootstrap table [closed] Warring: mysqli_query () expects parameter 2 to be string, object given in