title: extract time from now() in amazon redshift
body: <p>I am trying to extract the time part only (excluding milliseconds) from the date-time string in amazon redshift. </p>
  
  <p>I used:</p>
  
  <pre><code>Select now()::time;
  </code></pre>
  
  <p>But it is giving me error.</p>
  
  <p><code>Error running query: Specified types or functions (one per INFO message) not supported on Redshift tables</code>.</p>
  
  <p>Any help would be highly appreciated.</p>