How Yii2 data provider can return results for last 24h

Question

I need to return results from database table only where updated_at field is not older than 24h.

Inside my index action I have this code:

$dataProvider = new ActiveDataProvider([
    'query' => SearchStats::find(),
    'pagination' => [
        'pageSize' => 10,
    ],
]);

How can I modify this code to return me results that where inserted / updated in the past 24h hours ?

updated_at is integer, and I am using TimestampBehavior.

score 2 · Accepted Answer · edited May 23 '17 at 11:43

2

Change your query to:

use yii\db\Expression;

SearchStats::find()
    ->where(['>=', 'updated_at', new Expression('UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)')])

Related links:

edited May 23 '17 at 11:43

Community

answered Apr 30 '15 at 09:36

arogachev

I don't get any results now, and there are records made today o.O – offline Apr 30 '15 at 09:41
Could you show how `updated_at` is stored? Example with one value will be enough. – arogachev Apr 30 '15 at 09:43
integer(11) : 1430386702 – offline Apr 30 '15 at 09:44
If I change `NOW()` to `CURDATE()` it works... I am not sure why – offline Apr 30 '15 at 09:52
I updated the question according to your situation. But I think for this kind of data using date formats such as `timestamp` or `datetime` would be a better choice. – arogachev Apr 30 '15 at 09:57
I think that you have syntax error. Well I see that yii2 folks are storing `datetime` as `integer` like I did, I thought that is better way to go. Thanks for help ! – offline Apr 30 '15 at 09:59
It's just an example, they don't force you to use it. Fixed syntax error. Glad to help. – arogachev Apr 30 '15 at 10:03

1 Answers1