Compare dates between datetimes with Doctrine

Question

I have a Symfony2 application with a table that contains a date field, whose type is DateTime.
I need to get all the entities where that field value is now.

If I uses the following code, I get 0 results because Doctrine is comparing the DateTime object.

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

I need to only compare year, month, and day, not hours.

How can I achieve this?

Answer 1

I see this simple way:

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

then in your repository

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; } 

Answer 2

Method in repository

public function getDays(\DateTime $firstDateTime, \DateTime $lastDateTime) {     $qb = $this->getEntityManager()->createQueryBuilder()         ->select('c')         ->from('ProjectBundle:Calendar', 'c')         ->where('c.date BETWEEN :firstDate AND :lastDate')         ->setParameter('firstDate', $firstDateTime)         ->setParameter('lastDate', $lastDateTime)     ;      $result = $qb->getQuery()->getResult();      return $result; } 

And action

public function calendarAction() {     $currentMonthDateTime = new \DateTime();     $firstDateTime = $currentMonthDateTime->modify('first day of this month');     $currentMonthDateTime = new \DateTime();     $lastDateTime = $currentMonthDateTime->modify('last day of this month');      $days = $this->getDoctrine()         ->getRepository('ProjectBundle:Calendar')         ->getDays($firstDateTime, $lastDateTime);      return ['days' => $days]; }