SQL query convert to DQL (Doctrine for Symfony2)
<p>How can I use this query in DQL (Symfony2):</p>

<pre><code>SELECT id FROM user WHERE DATE_FORMAT( birth_date ,'%m-%d') = DATE_FORMAT( NOW() + INTERVAL 7 DAY ,'%m-%d')
</code></pre>

<p>I use beberlei/DoctrineExtensions, I added this is my config:</p>

<pre><code>orm:
dql:
    string_functions:
        date_format: DoctrineExtensions\Query\Mysql\DateFormat
        dateadd: DoctrineExtensions\Query\Mysql\DateAdd
</code></pre>

<p>I tried this, inside the UserRepository:</p>

<pre><code>$qb = $this-&gt;createQueryBuilder('U');
$qb -&gt;select('U')
    -&gt;where( 'DATE_FORMAT( U.birthDate, %m-%d) = DATE_FORMAT( CURRENT_TIMESTAMP() + INTERVAL 7 DAY, %m-%d' );
</code></pre>

<p>but it's not working.</p>

<p>Thanks in advance!</p>