/PHP/Laravel/Get recoed between two datetime laravel

Get recoed between two datetime laravel

public function scopeCreatedBetweenDates($query, array $dates)
{
    return $query->whereDate('created_at', '>=', $dates[0])
        ->whereDate('created_at', '<=', $dates[1])
}

Source: dev.to

Get recoed between two datetime laravel

$startDate = Carbon::createFromFormat('Y-m-d', '2021-06-01');
$endDate = Carbon::createFromFormat('Y-m-d', '2021-06-30');

$posts = Post::whereBetween('created_at', [$startDate, $endDate])->get();

Source: dev.to

Get recoed between two datetime laravel

public function scopeCreatedBetweenDates($query, array $dates)
{
    $start = ($dates[0] instanceof Carbon) ? $dates[0] : Carbon::parse($dates[0]);
    $end   = ($dates[1] instanceof Carbon) ? $dates[1] : Carbon::parse($dates[1]);

    return $query->whereBetween('created_at', [
        $start->startOfDay(),
        $end->endOfDay()
    ]);
}

Source: dev.to

Get recoed between two datetime laravel

$startDate = '2021-06-01';
$endDate = '2021-06-30';

Post::whereBetween(DB::raw('DATE(created_at)'), [$startDate, $endDate])->get();

Source: dev.to

Get recoed between two datetime laravel

$startDate = Carbon::createFromFormat('Y-m-d', '2021-06-01');
$endDate = Carbon::createFromFormat('Y-m-d', '2021-06-30');

$posts = Post::query()
    ->whereDate('created_at', '>=', $startDate)
    ->whereDate('created_at', '<=', $endDate)
    ->get();

Source: dev.to

Similar codes

2 votes291 views2 answers
How get the first item in foreach in laravel
PHP Laravel
0 vote302 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
-2 votes377 views1 answer
Errno: 150 foreign key constraint is incorrectly formed laravel 8
PHP Laravel
0 vote323 views1 answer
Debugbar:clear in laravel
PHP Laravel
3 votes278 views5 answers
Laravel delete multiple rows
PHP Laravel
1 vote315 views1 answer
Stack once laravel
PHP Laravel
16 votes293 views2 answers
Laravel create or update eloquesnt
PHP Laravel
0 vote301 views1 answer
Redirect back in laravel livewire
PHP Laravel
1 vote324 views1 answer
How to add an custom error to validater error in laravel
PHP Laravel
12 votes311 views1 answer
Laravel model without timestamps
PHP Laravel