yii2 find values between two timestamps

Question

What am trying is to query orders created between two dates

so i have

$maxdate = ; //timestamp value
$mindate = ; //timestamp value   


$orders = Orders::find()->where(["created_at" ..]) //stuck hre

IN normal words would be

find where created_at is between $maxdate and $mindate

How do i go about this?

Answer 1

You may achieve your goal by this

$orders = Orders::find()->where(["between", "created_at", $mindate, $maxdate])

This is the fully reference about building various of Queries