php日期条件，数据库日期时间为yii2

I am trying something like this. delivery_pick_ups.start_time = 2018-09-06 16:30:00 and $params['pick_date'] = 2018-09-06

$query->andFilterWhere([
    'and',
    ['>=', 'DATE(delivery_pick_ups.start_time)', $params['pick_date']],
    ['<=', 'DATE(delivery_pick_ups.end_time)', $params['pick_date']]
]);

I don't know if that is possible in yii2 yet or not.

You mixed up conditions

$query->andFilterWhere([
    'and',
    ['<=', 'DATE(delivery_pick_ups.start_time)', $params['pick_date']],
    ['>=', 'DATE(delivery_pick_ups.end_time)', $params['pick_date']]
]);

If you can use that you must use yii\db\Expression

$query->andFilterWhere([
   'and',
   ['>=', new \yii\db\Expression('DATE(delivery_pick_ups.start_time)'), $params['pick_date']],
   ['<=', new \yii\db\Expression('DATE(delivery_pick_ups.end_time)'), $params['pick_date']]
]);