How to use where date(timeline) in Laravel Query Builder

Question

select count(*) from laporan where date(w_laporan) = date(timestamps)

How can I use this query in Laravel 5 query builder? Thanks.

Answer 1

You may try something like this:

$someDate = '2015-06-09';
$result = \DB::select(
    \DB::raw("SELECT count(*) as total FROM items WHERE DATE(w_laporan) = :someDate"),
    ['someDate' => $someDate]
);

Check Raw Expression.

Answer 2

Try the following.

DB::table('laporan')
    ->whereRaw('date(w_laporan) = date(?)', [$timestamp])
    ->get();