使用Eloquent仅提取具有完整日期的项目

Question

I just want to extract items that have a complete date, Unfortunately video games do not always have a precise date While others are deleted.

For this reason some of my dates, rather than being composed "2017-03-29" they have: "2017" or "Deleted"

This is my code:

        $giochi = InfoGiochi::with('Giochi')
            ->where('data', '>=', Carbon::now()->subMonth())
        ->paginate(10);

I try with:

        ->where('data', date('Y-m-d'))

While:

Carbon::now()->subMonth()

I want to extract only complete dates, that is, composed "Y/m/d". Because now it also extracts incomplete dates, such as: "2017" or "delete".

Answer 1

Resolved with:

    $giochi = InfoGiochi::with('Giochi')
        ->whereMonth('data', '=', date('m'))
        ->whereYear('data', date('Y'))
    ->get();