Hello
How can I find the backup time in hour,minute, and second ?
Rman shows it in date format (21-MAY-2011)
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 498.56M DISK 00:01:19 21-MAY-11
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20110521T163837
Piece Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2011
_05_21\O1_MF_NNNDF_TAG20110521T163837_6XGJGGPW_.BKP
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 643847 21-MAY-11 C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
2 Full 643847 21-MAY-11 C:\ORACLEXE\ORADATA\XE\UNDO.DBF
3 Full 643847 21-MAY-11 C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
4 Full 643847 21-MAY-11 C:\ORACLEXE\ORADATA\XE\USERS.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 7.11M DISK 00:00:04 21-MAY-11
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20110521T163837
Piece Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2011
_05_21\O1_MF_NCSNF_TAG20110521T163837_6XGJK62V_.BKP
Control File Included: Ckp SCN: 643917 Ckp time: 21-MAY-11
SPFILE Included: Modification time: 21-MAY-11