These are just some notes that can help you figure out how to do sql query in a laravel controller for dates with timestamp matches a certain date

AND DATE(log_date) = '".date('Y-m-d',strtotime($date))."'"; // '2023-08-27'


use strtotime() change from 2023-08-20T08:46:45.759728Z to 1692521262