title: How do I insert a time value in Redshift in a time column?
body: <p>Given the following query
  <code>ALTER TABLE public.alldatatypes ADD x_time time ;</code>,
  how do I insert a value into <code>x_time</code>?</p>
  <p><strong>Time</strong> appears to be a valid column type according to the documentation.</p>
  <ul>
  <li><a href="https://docs.aws.amazon.com/redshift/latest/dg/r_Datetime_types.html#r_Datetime_types-time" rel="nofollow noreferrer">https://docs.aws.amazon.com/redshift/latest/dg/r_Datetime_types.html#r_Datetime_types-time</a></li>
  <li><a href="https://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html" rel="nofollow noreferrer">https://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html</a></li>
  </ul>
  <p>However, when I try to do an insert, I always get an error.</p>
  <p>Insert query: <code>insert into public.alldatatypes(x_time) values('08:00:00');</code></p>
  <p>Error:</p>
  <blockquote>
  <p>SQL Error [500310] [0A000]: Amazon Invalid operation:
  Specified types or functions (one per INFO message) not supported on
  Redshift tables.;</p>
  </blockquote>
  <p>I do not want to use another column type.
  I am testing all the column types defined in the documentation.</p>