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'