Home / Questions / 213785
Accepted
Alberto Ortega
Asked: 2020-11-15 13:52:16 +0800 CST 2020-11-15 13:52:16 +0800 CST

Query a previous date equivalent to 10 days?

  • 772

I am working with laravel and using eloquent to query my SQL database, I need to make a query to get the records of a table. Said query should only bring the data that was created 10 days ago and that is not validated.

Modelo::where('Validacion', '!=', 1)
->whereDate('created_at', '=', Carbon::now()->format('Y-m-d'))
->get();

I don't know how to calculate the current date minus 10 days.

laravel

3 Answers

  1. Best Answer

    You could subtract the days like this:

    Modelo::where('Validacion', '!=', 1)
  ->whereDate('created_at', '=', Carbon::now()->add(-10, 'day')->format('Y-m-d'))
  ->get();

    Or this other one:

    Modelo::where('Validacion', '!=', 1)
  ->whereDate('created_at', '=', Carbon::now()->subDays(10)->format('Y-m-d'))
  ->get();

    I also leave you the link to the documentation: https://carbon.nesbot.com/docs/#api-addsub .

    Luck!

    • 3

  2. I leave you this variation that is a little more correct and I explain why

    Modelo::where('Validacion', '<>', 1)
  ->whereDate('created_at', now()->subDays(10))
  ->get();
    • The negation (!=) although it is accepted, is from PHP and not from MySql, so "<>" is more correct.
    • In the "where", the operator "=" is already implicit, so it is not necessary.
    • "Carbon::now()" has a Helper named "now()".
    • The format is not necessary in the query since the handler(Eloquent) uses objects(Carbon/Date), not a text string.
    • 0

  3. you can do it like this I leave you this query model so that you can adapt it to your needs

    $ventasAnteriores = DB::table('ventas')
                ->select(DB::raw('SUM(venta) as anteriores'))
                ->where('created_at', 'like', '%'.date('Y-m-d', strtotime('d'. '-10 days')).'%')
                ->get();

    I did it that way and it has worked for me to check the sales of 10 days ago

    • 0