title: YEAR function is not Working in Symfony 2
body: <p>Not able to use YEAR() in symfony 2 doctrine..My code is given below</p>
  
  <pre><code>   $users = $this-&gt;getEntityManager()
                 -&gt;createQuery("SELECT YEAR(u.dob) from AcmeDemoBundle:AppUsers u")
                 -&gt;getResult();
  </code></pre>
  
  <p>While running this code,it shows the following error</p>
  
  <blockquote>
    <p>[Syntax Error] line 0, col 7: Error: Expected known function, got 'YEAR'</p>
  </blockquote>
  
  <p>Why this happen ??</p>