title: How to update hours in timestamp without effecting date in postgreSql?
body: <p>I have two columns in_time and out_time, both are timestamps with timezone. When I try to update/change hours, date also effected, I only want to change hours without effecting date(Database:Postgresql)</p>
  <pre><code>update activity
      set in_time =  in_time - interval '5.5 hours',
          out_time = gout_time - interval '5.5 hours'
      where emp_id = 72;
  </code></pre>
  <p>Inputs</p>
  <pre><code>  in_time ==&gt; 2022-02-03 19:30:00:000 +530
    out_time ==&gt; 2022-02-03 04:30:00:000 +530
  </code></pre>
  <p>Output I am getting</p>
  <pre><code>   in_time ==&gt; 2022-02-03 14:00:00:000 +530
     out_time ==&gt; 2022-02-02 23:00:00:000 +530
  </code></pre>
  <p>Expected Output</p>
  <pre><code>   in_time ==&gt; 2022-02-03 14:00:00:000 +530
     out_time ==&gt; 2022-02-03 23:00:00:000 +530
  </code></pre>