title: Subtract an interval from a time value
body: <p>I want to get the time 1 hour before the current time in PostgreSQL. How can I do that?</p>
  
  <p>Say, for example, currently the time is <code>'17:37:06'</code>, then I want the result output as <code>'16:37:06'</code></p>