How to extract hour, minutes and seconds from a DATE
<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>