TP5时间戳time和日期date搜索

1时间戳用这种$where['order_time'] = ['between', strtotime($input['start_time']).",".strtotime($input['end_time'])];

日期格式用这种会报错SQLSTATE[42S22]: Column not found: 1054 Unknown column 'delivery_time' in 'where clause'意思是搜索的值是字符串但是没加单引号，但是加了单引号就不是变量了

2日期用这种->where('delivery_time','between time',[$input['delivery_time'],$input['delivery_time2']])

这种就不会说搜索的值是字符串了

if($input['start']  != '' && $input['end'] == ''){
            $where['order_time'] = ['gt', strtotime($input['start'])];
        }
        if($input['start']  == '' && $input['end'] != ''){
            $where['order_time'] = ['lt', strtotime($input['end'])];
        }
        if($input['start']  != '' && $input['end'] != ''){
            $where['order_time'] = ['between', strtotime($input['start']).",".strtotime($input['end'])];
        }