title: How to convert varchar into time on Redshift- " Column "duration" has unsupported type "time without time zone"
body: <p>I have a column where I time stored as varchar (e.g."00:00:00") and want to CAST or CONVERT it into time which is pretty simple but being new Redshift DB I am struggling with an error that states " Column "duration" has unsupported type "time without time zone".</p>
  
  <p>The commands CAST and Convert works when I am trying to use it on individual strings like <code>SELECT CAST('09:47:11' AS TIME)</code> or <code>SELECT Convert(TIME,'09:47:11')</code> but not when I am trying to pass an entire column.</p>
  
  <p>Please help me with it!</p>