title: How can I use DATE() in Doctrine 2 DQL?
body: <p>IN Symfony, when i used the following query with DATE function in the mysql i get a error </p>
  
  <pre><code>    SELECT employer.companyName AS employerName, jobs.jobId, jobs.industryId, 
  jobs.focusId, jobs.companyName, jobs.employerId, jobs.jobTitle, DATE(jobs.createdDate) AS 
  createdDate , DATE(jobs.endDate) AS endDate , jobs.replyTo, jobs.featured , jobs.jobType, 
  jobs.status  FROM Acme\\AppsBundle\\Entity\\Jobs jobs , Acme\\AppsBundle\\Entity\\Employer 
  employer  WHERE  jobs.employerId = employer.employerId  GROUP BY  jobs.jobId  ORDER BY 
  jobs.jobId DESC 
  </code></pre>
  
  <p>Why is this and what sort of workaround is there to overcome this situation, in the Database these fields i.e end_date is are stored as mysql type 'date'</p>
  
  <pre><code>    [2014-09-17 05:52:42] request.CRITICAL: Uncaught PHP Exception Doctrine\ORM\Query
  \QueryException: "[Syntax Error] line 0, col 138: Error: Expected known function, got 
  'DATE'" at /.../Doctrine/ORM/Query/QueryException.php line 52 {"exception":"[object] 
  (Doctrine\\ORM\\Query\\QueryException: [Syntax Error] line 0, col 138: Error: Expected known function, got 'DATE' at /var/w.../doctrine/orm/lib/Doctrine/ORM/Query
  /QueryException.php:52, Doctrine\\ORM\\Query\\QueryException: SELECT employer.companyName 
  AS employerName, jobs.jobId, jobs.industryId, jobs.focusId, jobs.companyName, jobs.employerId, jobs.jobTitle, DATE(jobs.createdDate) AS createdDate , DATE(jobs.endDate) 
  AS endDate , jobs.replyTo, jobs.featured , jobs.jobType, jobs.status  FROM Acme\\AppsBundle
  \\Entity\\Jobs jobs , Acme\\AppsBundle\\Entity\\Employer employer  WHERE  jobs.employerId 
  = employer.employerId  GROUP BY  jobs.jobId  ORDER BY  jobs.jobId DESC  at /var/w...
  /doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41)"} []
  </code></pre>