Yii2活动记录筛选器等数值(以列为单位)

使用数组语法时 != 条件,数组的第三个元素被视为值,因此它将作为值转义。所以你实际上是在创造条件,比如 date_received != 'date_released' yii\db\Expression()

$unit_received = \common\models\dts\DtsTrack::find()
    ->where(['!=', 'dts_track.date_received', new Expression('dts_track.date_released')])
    ->andWhere(['!=', 'dts_track.time_received', new Expression('dts_track.time_released')]);

或者完全避免数组语法:

$unit_received = \common\models\dts\DtsTrack::find()
    ->where('date_received != date_released')
    ->andWhere('time_received != time_released');