postgresql - Yii2:SQL 查询中的函数

Question

我需要使用 Yii2 框架从名为 persons 的表中选择 21 岁或以下的人。

persons = (id, birthdate)

public static function findByBirthday($idper) {
    $query = Persons::find()
        ->select([
            Persons::tableName().".[[id]]", 
            Persons::tableName().".[[birthday]]"
        ])
        ->where([
            '<=',
            'select age(birthday, NOW())',
            21
        ])

    return $query->asArray()->all();
}

Answer 1

如果生日是有效的DATE类型

public static function findByBirthday($idper) {
    $query = Persons::find()
        ->select([
            Persons::tableName().".[[id]]", 
            Persons::tableName().".[[birthday]]"
        ])
        ->where([
            '<=',
            'EXTRACE(year from age(birthday))',
            21
        ])

    return $query->asArray()->all();
}

或

  ->where(   'EXTRACE(year from age(birthday))   <= 21')