title: How to extract hour, minutes and seconds from a DATE
body: <p>I have the following query:</p>
  
  <pre><code>select cast(max_bid_ts as TIMESTAMP) from my_table;
  </code></pre>
  
  <p>I cast the <code>max_bid_ts</code> because it was a double and I wanted to be a <code>TMESTAMP</code>. This query returns something like this </p>
  
  <pre><code>2016-04-21 12:41:46.313999872
  </code></pre>
  
  <p>I only want the hour:minutes:seconds part. In this case would be 12:41:46. What would be the best way to do this? </p>