How to get my data values sum() from past 24 hours in symfony using DQL?

Question

I need to set CronJob and do calculations, How can I reach the timestamp 24 hours ago?

  $queryBuilder->where($queryBuilder->expr()->gte('ema.date','data24ago'))
        ->setParameters(['member' => $member,
            'date24ago' => (new \Datetime)->getTimestamp() - 24 * 3600
            ]);

Is there any better approach?

Answer 1

If you want to set via PHP Try simply:

 $queryBuilder->where($queryBuilder->expr()->gte('ema.date','data24ago'))
        ->setParameters(['member' => $member,
            'date24ago' => new \Datetime('yesterday'),
            ]);