title: convert time to decimal data type in PostgreSQL
body: <p><a href="https://i.stack.imgur.com/Q98bQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Q98bQ.png" alt="enter image description here" /></a></p>
  <p>In PostgreSQL / pgadmin -  How do I cast timestamp (HH:MM:SS) as decimal so I can multiply by hourly_rate (XX.YY$) and get total charge_amount?</p>
  <p>For the life of me I can't find any reasonably simple solution on Google or this forum.</p>
  <p>Can it be that's it's not possible?</p>