@daisha
To get data between two dates and times in Laravel, you can use the following code:
1 2 3 4 5 6 7 |
use AppModelsModelName; use CarbonCarbon; $startDateTime = Carbon::parse('2022-01-01 00:00:00'); $endDateTime = Carbon::parse('2022-01-31 23:59:59'); $data = ModelName::whereBetween('created_at', [$startDateTime, $endDateTime])->get(); |
In this code snippet, replace ModelName
with the name of your model and created_at
with the column containing the date and time you want to filter by. Adjust the $startDateTime
and $endDateTime
variables to the desired start and end dates and times. The whereBetween
method will retrieve records where the created_at
column value falls within the specified range.