title: Mysql Dayofyear in leap year
body: <p>In the following query the leap year is not taken into account. </p>
  
  <pre><code> SELECT      e.id,
               e.title,
               e.birthdate
   FROM        employers e
   WHERE       DAYOFYEAR(curdate()) &lt;= DAYOFYEAR(e.birthdate)
   AND         DAYOFYEAR(curdate()) +14 &gt;= DAYOFYEAR(e.birthdate)
  </code></pre>
  
  <p>So in this query the birthdate of someone who is born in a leap year has got a different dayofyear in a non leap year. </p>
  
  <p>How can i adjust the query to make sure it also works in a leap year?</p>
  
  <p>The mysql version i have is: 5.0.67</p>