select
r.ON_OFF AS onOrOff,
r.ON_DATE AS onDate,
round(to_number(r.off_date- r.on_date)*24) AS hours
FROM R_POWER_ON_OFF
select
r.ON_OFF AS onOrOff,
r.ON_DATE AS onDate,
round(to_number(r.off_date- r.on_date)*24) AS hours
FROM R_POWER_ON_OFF