select SNAP_ID,to_char(BEGIN_INTERVAL_TIME,‘YYYY/MM/DD HH24:MI’) TIME from DBA_HIST_SNAPSHOT order by 1;