title: Doctrine ORM - Get data posted on current week
body: <p>I want to get the data from the DB (my sql) which are all posted for current week. I am using Doctrine ORM, my sql. I think i need to use createQueryBuilder for this but i dont know exactly how to use that for my situation. I tried with the below statement, but didnt worked.</p>
  
  <pre><code>......-&gt;createQueryBuilder('t')
          -&gt;where('WEEK(t.dateCreated) = WEEK(CURDATE())')                      
          -&gt;getQuery()
          -&gt;getResult(); 
  </code></pre>
  
  <p>Please help me on this.</p>