title: How can I format a datetime column to only print hh:mm:ss in an ace report?
body: <p>Informix-SQL 4.10:</p>
  
  <p>I have a <code>DATETIME YEAR TO SECOND</code> column and would like to just printout the hours, minutes and second (HH:MM:SS) in an ACE report. I tried the following three ACE statements, but they all gave compiler errors:</p>
  
  <pre><code>PRINT TimeStampCol USING "HH:MM:SS"
  PRINT TimeStampCol HOUR TO SECOND
  PRINT TimeStampCol[12,19]  
  </code></pre>