title: INTERVAL 1 MONTH not working With symfony2 doctrine?
body: <p>I am stuck here and i spend last 2 days resolving this issue but failed. I am writing a query inside my repository to get the entries for current month. here is my query:-</p>
  
  <pre><code>$this-&gt;getEntityManager()
   -&gt;createQuery('SELECT count(a) FROM CollegeStudentBundle:StudentAttendance a where a.student_id='.$id.'
   and a.date &gt; DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 1 MONTH)')
  </code></pre>
  
  <p>When I try to run this it gives me an error </p>
  
  <pre><code>[Syntax Error] line 0, col 133: Error: Expected Doctrine\ORM\Query\Lexer::T_COMMA, got '1'
  </code></pre>
  
  <p>Even I tried <a href="https://stackoverflow.com/questions/7672125/how-to-make-doctrine-expression-doctrine-1-2-try-to-get-last-7-days">this thing</a> but didn't helped me.</p>