Convert DateTime to Date Doctrine php

Question

Hello i'm working with Doctrine (php) and mysql.

I need to convert my Datetime field to a Date. But Doctrine date manipulator function are rare ...

I've try some manipulation with DATE_ADD and DATE_DIFF but without succes.

The purpose is to GROUP BY Date to display statistics per day.

Answer 1

Simply use GROUP BY DATE(your_column).