select month year and date in date field

I have the value $date='2017-10-30' in my data table I have the field requested_on has '2017-10-30 15:40:10' I want to select the row using query.My query doesn't select the row which has the $date value

$reportdate =DB::table('asset_request')
 ->where('asset_request.requested_on','=',$date)->distinct()
 ->orderby('asset_request.request_id','DESC')->get();

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2z81yBm
via IFTTT