Home / Questions / 348757
Accepted
Luis
Asked: 2020-04-24 09:08:11 +0800 CST 2020-04-24 09:08:11 +0800 CST

Difference of days between two dates

  • 772

I have a table in which I have two fields called created_at and updated_at in a table called processes, what I want to do is compare how many days there are between those two fields

I am using laravel 6

controller

$processes = Process::findOrFail(Crypt::decrypt(base64_decode($id)));
return view('clientes.show', compact('processes', 'histories', 'diligences', 'services', 'iva', 'dias'));

Query

SELECT TIMESTAMPDIFF(DAY,created_at, updated_at) AS days FROM processes 
WHERE id = 1
laravel

2 Answers

  1. Best Answer

    I already could, I put this in my model and call it in the blade view

    public function dias(){
        $fecha1 = date_create($this->created_at);
        $fecha2 = date_create($this->canceled_at);
        $dias = date_diff($fecha1, $fecha2)->format('%R%a');
        return $dias;
    }

    blade

    {{ $processes->dias() + 0 }}
    • 1

  2. You can use the method diffInDaysthat Carbon already provides in Laravel.

    You should:

    • Have your model created
    • Get the old date and assign it in a variable
    • Get the recent date and assign it in a variable
    • You store the result in days in a third variable where you pass the most recent date as an argument to the aforementioned method.

    Example

    $fechaAntigua  = Modelo::first()->created_at;
$fechaReciente = Modelo::first()->updated_at;

$cantidadDias = $fechaAntigua->diffInDays($fechaReciente);

    EDITION

    I add an example of using the method diffInDays()from Tinker

    >>> $fechaAntigua = App\User::first()->created_at;

    => Illuminate\Support\Carbon @989686800 {#3113
         date: 2020-05-01 18:37:21.0 America/Mexico_City (-05:00),
         timezone: "America/Mexico_City",
       }
>>> $fechaNueva = App\User::first()->updated_at;

    => Illuminate\Support\Carbon @1589413041 {#3127
         date: 2020-05-13 18:37:21.0 America/Mexico_City (-05:00),
         timezone: "America/Mexico_City",
       }
>>> $fechaAntigua->diffInDays($fechaNueva);

    => 12

    Reference

    • 0