How to pull data from the database for the last 3 hours in yii2 using active record methods?

Question

MySQL

The database has a datetime column.
I fill it in using the date("Ymd H:i:s") function.
The task is to pull records from the database for the last three hours.
How to do it?

$postdb = Posts::find(['login_id' => $id, 'type'=>'update'])->where(какая-то магия)->All();

Answer 1

$postdb = Posts::find(['login_id' => $id, 'type'=>'update'])
    ->where(['>=', 'some_date_column', new \yii\db\Expression('NOW() - INTERVAL 3 HOUR')])
    ->all();

Answer 2

There is such a function in mysql "between"
Try to use it.