How do I get the difference in minutes from 2 timestamp columns?
select
  round(
    (cast(current_timestamp as date) - cast(&lt;other_timestamp&gt; as date))
    * 24 * 60
  ) as diff_minutes
from &lt;some_table&gt;;


This is what I used to calculate the difference between the current timestamp and a heart beat table entry for latency monitoring.