/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

1 vote194 views1 answer
Laravel pagination publish command
PHP Laravel
-1 vote155 views1 answer
Authenticate user with phone laravel
PHP Laravel
0 vote134 views1 answer
How to login laravel passport with postman
PHP Laravel
31 votes138 views6 answers
Update or create laravel
PHP Laravel
11 votes143 views3 answers
Laravel log reader
PHP Laravel
1 vote184 views1 answer
Laravel mongodb field delete (key delete) (column delete) drop
PHP Laravel
0 vote142 views1 answer
How return cutomize error text the firstOrFail laravel exeption
PHP Laravel
0 vote140 views1 answer
Get post data in laravel
PHP Laravel
5 votes137 views3 answers
Crrate model in laravel
PHP Laravel
1 vote143 views1 answer
How validate the becrypt password in laravel
PHP Laravel