title: How to extract the date part from a timestamp field in apache drill?
body: <p>I have a timestamp field in a drill table (say date_time), How can I extract the date field only from the same. Saw lots of date operation functions <a href="https://drill.apache.org/docs/date-time-functions-and-arithmetic/" rel="nofollow noreferrer">here</a> but none of them helped.</p>
  
  <p>Here is the sample data,</p>
  
  <pre><code>+------------------------+
  |       date_time        |
  +------------------------+
  | 2017-01-01 03:45:58.0  |
  | 2017-01-01 21:42:20.0  |
  | 2017-01-01 15:08:47.0  |
  | 2017-01-01 19:59:39.0  |
  | 2017-01-01 22:37:24.0  |
  +------------------------+
  </code></pre>
  
  <p>I need an output like follows,</p>
  
  <pre><code>+-------------+
  |  date_time  |
  +-------------+
  | 2017-01-01  |
  | 2017-01-01  |
  | 2017-01-01  |
  | 2017-01-01  |
  | 2017-01-01  |
  +-------------+
  </code></pre>
  
  <p>I don't want to do string operations. :)</p>