title: Calculate the sum of time column in PostgreSql
body: <p>Can anyone suggest me, the easiest way to find summation of time field in <code>POSTGRESQL</code>. i just find a solution for <code>MYSQL</code> but i need the <code>POSTGRESQL</code> version.</p>
  
  <p><strong>MYSQL</strong>: <a href="https://stackoverflow.com/questions/3054943/calculate-sum-time-with-mysql">https://stackoverflow.com/questions/3054943/calculate-sum-time-with-mysql</a></p>
  
  <pre><code>SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(timespent))) FROM myTable;
  </code></pre>
  
  <p>Demo Data</p>
  
  <pre><code>id   time 
  1   1:23:23
  2   4:00:23
  3   9:23:23
  </code></pre>
  
  <p><strong>Desired Output</strong></p>
  
  <p>14:47:09</p>