PGsql解决时差24H

SELECT
    sa_ed_time,
    sa_st_time,
    case when 
sa_ed_time > sa_st_time     
then        
    extract(EPOCH FROM (sa_ed_time - sa_st_time)::INTERVAL)/3600   
else  
    extract(EPOCH FROM (sa_ed_time - sa_st_time)::INTERVAL)/3600  + 24
 end  as w_time
FROM
    tbl_sagyo
WHERE
    sa_no = '522515' AND
    sa_line_no = '10'
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/sunxun/p/5261192.html