yii2 - 如何在 Yii2 中比较数据库中的日期

Question

$time = new \DateTime('now');
$today = $time->format('Y-m-d');
$programs=Programs::find()->where(['close_date' >= $today])->all();

这是今天程序的代码，其 close_date大于 today's date .我收到错误:

"Invalid Parameter -yii\base\InvalidParamException Operator '1' requires two operands".

Answer 1

如果你想写 where条件作为数组的代码应该是这样的:

$programs = Programs::find()->where(['>=', 'close_date', $today])->all();

查询 official documentation更多细节:

Additionally you can specify arbitrary operators as follows: A condition of ['>=', 'id', 10] will result in the following SQL expression: id >= 10.