set pages 999
select  scn
,       to_char(time_dp, ‘hh24:mi:ss dd/mm/yyyy’) time
from    smon_scn_time
order by scn
/