laravel Date Compare with created at field timestamp

1)-------------------------------------------------- public function index(Request $request) { $startDate = '2022-01-01'; $endDate = '2022-07-30'; $posts = Post::whereBetween('created_at', [$startDate, $endDate])->get(); return $posts; }

2)--------------------------------------------------

public function index(Request $request)

    {

        $startDate = Carbon::createFromFormat('Y-m-d', '2022-06-01')->startOfDay();

        $endDate = Carbon::createFromFormat('Y-m-d', '2022-06-30')->endOfDay();

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

        return $posts;

    }

3)-------------------------------------------------

public function index(Request $request)

    {

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

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

        

        $posts = Post::whereDate('created_at', '>=', $startDate)

            ->whereDate('created_at', '<=', $endDate)

            ->get();

        return $posts;

    }

4)--------------------------------------------

public function index(Request $request)

    {

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

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

        $users = User::whereDate('start_at', '>=', $startDate)

                ->whereDate('end_at', '<=', $endDate)

                ->get();

        return $users;

    }

5)-------------------------------------------

SELECT * FROM posts WHERE DATE(created_at) BETWEEN '2022-06-01' AND '2022-06-30'

6)------------------------------------------------------------------------

$startDate = '2022-06-01';

$endDate = '2022-06-30';

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