getting rows at a certain date and a fixed time in Laravel

Question

I have a date in the following format : ('Y-m-d') I'm trying to do a query that brings all rows in a certain date but only from 12:00 AM to 1:00 AM

The following will bring the required data but for today. I need the same but for the entered date $sel_date. How can I replace the carbon::now() with $sel_date ?

->whereBetween('created_at', [
             \Carbon\Carbon::now()->format('Y-m-d 00:00:00'),
             \Carbon\Carbon::now()->addHours(1)->format('Y-m-d 01:00:00')
                    ])

If you're specifying the hour, you don't need to do addHours(1) — aynber
– aynber, Commented Oct 17, 2019 at 17:33

Furqan Ansari · Accepted Answer · 2019-10-17 17:22:01Z

2

->whereBetween('created_at', [
             \Carbon\Carbon::parse($sel_date)->format('Y-m-d 00:00:00'),
             \Carbon\Carbon::parse($sel_date)->addHours(1)->format('Y-m-d 01:00:00')
                    ])

answered Oct 17, 2019 at 17:22

Furqan Ansari

1508 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Salim Djerbouh · Accepted Answer · 2019-10-17 17:26:05Z

1

Just add 12 hours for 12 am and 1 hour for 1 am to a created instance of carbon from your date variable

Given this user object for example

=> App\User {#3065
     id: 1,
     name: "something",
     email: "[email protected]",
     email_verified_at: null,
     created_at: "2019-10-17 13:16:25",
     updated_at: "2019-10-17 13:16:25",
   }

This query returns it

$sel_date = '2019-10-17';
return User::whereBetween('created_at', [
    Carbon::createFromDate($sel_date)->addHours(13),
    Carbon::createFromDate($sel_date)->addHours(14),
])->get();

Hope this helps

answered Oct 17, 2019 at 17:26

Salim Djerbouh

11.1k6 gold badges35 silver badges65 bronze badges

Collectives™ on Stack Overflow

getting rows at a certain date and a fixed time in Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related