title: Get week of the year from date in apache drill
body: <p>I'm trying to convert a timestamp in some data (using apache drill) to the week of year. </p>
  
  <p>According to the <a href="https://drill.apache.org/docs/date-time-functions-and-arithmetic/" rel="nofollow" title="drill date time reference.">reference</a> the closet thing I can see is the "extract" function however this only works for YEAR, MONTH, DAY, HOUR, MINUTE, SECOND units. </p>
  
  <p>Original date example</p>
  
  <pre><code>ID, START_DATE
  1, 2014-07-07T13:20:34.000Z 
  </code></pre>
  
  <p>Query (something like this)</p>
  
  <pre><code>SELECT ID, EXTRACT(WEEK, START_DATE) FROM MY_TABLE; 
  </code></pre>
  
  <p>And get a result like this: </p>
  
  <pre><code>ID, START_DATE
  1, 27 
  </code></pre>