select xv.inst_id, -- INST_ID NUMBER xv.name_kfvacfss, -- FS_NAME VARCHAR2(1024) xv.voldev_kfvacfss, -- VOL_DEVICE VARCHAR2(256) xv.sname_kfvacfss, -- SNAP_NAME VARCHAR2(1024) to_date( -- CREATE_TIME DATE xv.time_kfvacfss,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') from x$kfvacfss xv