Home / Questions / 92044
Accepted
lucho
Asked: 2020-08-02 07:30:18 +0800 CST 2020-08-02 07:30:18 +0800 CST

How to convert a datetime to date with format ('dmy') doing a select with query builder in laravel?

  • 772

I have the following code I want to return the date found in my database mysqlin datetime format. How do I convert it to date and format it from a selectquery builder with laravel?.

public function fecha(){
$fechas= DB::table('detail_books')->select('DATE_FORMAT('fechallegada','%d-%m-%Y')')->get();
return view("factura",compact('fechas'));
}

However I get an error in the select.

Cheers

mysql

1 Answers

  1. Best Answer

    syntax error

    Try this:

     public function fecha(){
    $fechas= DB::table('detail_books')->select("DATE_FORMAT(fechallegada,'%d-%m-%Y')")->get();
    return view("factura",compact('fechas'));
  }

    Using the combination of single quotes in the following statement is generating the error.

    'DATE_FORMAT('fechallegada','%d-%m-%Y')'

    You should try replacing with:

    "DATE_FORMAT(fechallegada,'%d-%m-%Y') as fechallegada"

    Update

    You must use selectRawto format from the query. The code should be as follows:

    public function fecha(){ 
$fechas= DB::table('detail_books')->selectRaw("DATE_FORMAT(fechallegada,'%d-%m-%Y')")->get(); 
return view("factura",compact('fechas')); 
}
    • 0