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'