How to organize a query with a date range in yii2?

Question

Yii

You need to sample over a period.
I do this but it doesn't work

$leftDate = '2016-01-01'; 
$rightDate = date('Y-m-d');
$trips = Trip::find()
            ->joinWith(['idDrivers'])
            ->where('Date_start >= :left and Date_end <= :right', [':left' => $leftDate, ':right' => $rightDate])
            ->all();

The problem is probably that the dates in the database are stored in the dateTime format, they have time. I only need dates.

Answer 1

$leftDate = '2016-01-01'; 
$rightDate = date('Y-m-d');
$trips = Trip::find()
            ->joinWith(['idDrivers'])
            ->where('DATE(Date_start) >= :left and DATE(Date_end) <= :right', [':left' => $leftDate, ':right' => $rightDate])
            ->all();

Answer 2

tigor.com.ua/blog/2008/08/23/date_comparison_by_be...
You need BETWEEN