title: Use SQL CONVERT within Doctrine
body: <p>How can I use CONVERT from mysql within Doctrine.</p>
  
  <pre><code>$now = new \DateTime('now', new DateTimeZone('Europe/Berlin'));
  $selectedDate = new \DateTime($flightDate);
  $selectedDate = $selectedDate-&gt;format('Y-m-d H:i:s');
  $query= $this-&gt;createQueryBuilder('o')
          -&gt;where('CONVERT(:selectedDate, DATE) + o.time &gt;= :currentTime')
          -&gt;setParameter('selectedDate', $selectedDate)
          -&gt;setParameter('currentTime', $now-&gt;format('Y-m-d H:i:s'))
          -&gt;setMaxResults(20)
          -&gt;getQuery();
  </code></pre>
  
  <p>For which I get an error </p>
  
  <blockquote>
    <p>Error: Expected known function, got 'CONVERT'</p>
  </blockquote>