How to write a query to select a unique date in Doctrine?

Question

Doctrine ORM

Good afternoon, there is a table:

id int - statistics ID
client_id int - user ID
type int - view, click or download
from_type int - article or file
from_id int - article or file ID date
datetime - Date

for the whole day, the rest is skipped).

Answer 1

Solution (not mine): distinct date(date_field)

Answer 2

Well, for example, through qb

->andWhere('DATE(stat.datetime ) >= :start and DATE(stat.datetime ) <= :finish')
->setParameter('start', $start->format('Y-m-d'))
->setParameter('finish', $finish->format('Y-m-d'))
...