How to construct a query in laravel to select all news for a certain month?

Question

Laravel

It is necessary to extract from the database all published news of a certain category (for example, "second"). I do this with a simple query:

$data['news']=$news->where([
            ['category', '2'],
            ['published', '1']
        ])->get();

But this query needs to be improved so that there is a selection of news only for a certain month, for example, for September (09). I just can't figure out how to modify this line to make such a selection. If I wrote a query in pure SQL, I would use DATE_FORMAT, but here a record like
[date_format('date', '%m'), '09']
does not
work Please help me understand!

Answer 1

Try
whereMonth('date', '=', 9);

Answer 2

Kuri Carbon