select id, event_time
from   table
order by to_char(systimestamp+1-event_time,'HH24:MI') desc;