使用 Doctrine 比较日期时间之间的日期

2022-01-03 00:00:00 datetime php symfony doctrine doctrine-orm

我有一个带有日期字段的表格的 Syfmony2 应用程序.此日期字段是 DateTime 类型.

I have a Syfmony2 app with a table which has a date field. This date field is a DateTime type.

我需要获取与现在相同日期的所有实体.

I need to get all the entities which the same date as now.

但如果我这样做:

$now = new DateTime();
$data = $entityRepository->findByDate($now);

我得到 0 个结果，因为 Doctrine 正在比较 DateTime 对象，我只需要比较年、月和日，而不是小时……只比较日期对象，而不是 DateTime.

I get 0 results because Doctrine is comparing the DateTime object, and I need to compare only the year, month and day, not hours... only de Date object, not the DateTime.

有什么想法吗?谢谢:D

Any Idea? Thanks :D

推荐答案

我看到了这个简单的方法:

I see this simple way:

$now = new DateTime();

$data = $entityRepository->getByDate($now);

然后在您的存储库中

public function getByDate(Datetime $date)
{
    $from = new DateTime($date->format("Y-m-d")." 00:00:00");
    $to   = new DateTime($date->format("Y-m-d")." 23:59:59");

    $qb = $this->createQueryBuilder("e");
    $qb
        ->andWhere('e.date BETWEEN :from AND :to')
        ->setParameter('from', $from )
        ->setParameter('to', $to)
    ;
    $result = $qb->getQuery()->getResult();

    return $result;
}

相关文章