Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

TO_CHAR(last_ddl_time,dd-mon-yyyy hh24

SQL> SQL> SELECT owner, object_name, object_type, TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi') last_ddl_time   2  FROM dba_objects   3  where rownum<50; OWNER ------------------------------ OBJECT_NAME ---------------------------------------------------------------------------------------------------- OBJECT_TYPE         LAST_DDL_TIME ------------------- ----------------- SYS ICOL$ TABLE               07-feb-2006 22:38 SYS I_USER1 INDEX               07-feb-2006 22:10 SYS CON$ TABLE               07-feb-2006 22:38 SYS UNDO$ TABLE               07-feb-2006 22:10 SYS C_COBJ# CLUSTER             07-feb-2006 22:10 SYS I_OBJ# INDEX               07-feb-2006 22:10 SYS PROXY_ROLE_DATA$ TABLE               07-feb-2006 22:10 SYS I_IND1 INDEX               07-feb-2006 22:10 SYS I_CDEF2 INDEX               07-feb-2006 22:10 SYS I_PROXY_ROLE_DATA$_1 INDEX               07-feb-2006 22:10 SYS FILE$ TABLE               07-feb-2006 22:10 SYS UET$ TABLE               07-feb-2006 22:10 SYS I_FILE#_BLOCK# INDEX               07-feb-2006 22:10 SYS I_FILE1 INDEX               07-feb-2006 22:10 SYS I_CON1 INDEX               07-feb-2006 22:10 SYS I_OBJ3 INDEX               07-feb-2006 22:10 SYS I_TS# INDEX               07-feb-2006 22:10 SYS I_CDEF4 INDEX               07-feb-2006 22:10 SYS IND$ TABLE               07-feb-2006 22:38 SYS SEG$ TABLE               07-feb-2006 22:10 SYS C_TS# CLUSTER             07-feb-2006 22:10 SYS I_FILE2 INDEX               07-feb-2006 22:10 SYS COL$ TABLE               07-feb-2006 22:38 SYS I_TS1 INDEX               07-feb-2006 22:10 SYS I_UNDO2 INDEX               07-feb-2006 22:10 SYS CLU$ TABLE               07-feb-2006 22:10 SYS PROXY_DATA$ TABLE               07-feb-2006 22:10 SYS I_PROXY_DATA$ INDEX               07-feb-2006 22:10 SYS I_OBJ1 INDEX               07-feb-2006 22:10 SYS I_COL2 INDEX               07-feb-2006 22:10 SYS I_OBJ2 INDEX               07-feb-2006 22:10 SYS I_CCOL1 INDEX               07-feb-2006 22:10 SYS TS$ TABLE               07-feb-2006 22:38 SYS C_FILE#_BLOCK# CLUSTER             07-feb-2006 22:10 SYS C_USER# CLUSTER             07-feb-2006 22:10 SYS I_UNDO1 INDEX               07-feb-2006 22:10 SYS BOOTSTRAP$ TABLE               07-feb-2006 22:10 SYS FET$ TABLE               07-feb-2006 22:10 SYS I_TAB1 INDEX               07-feb-2006 22:10 SYS CCOL$ TABLE               07-feb-2006 22:38 SYS USER$ TABLE               07-feb-2006 22:52 SYS I_CON2 INDEX               07-feb-2006 22:10 SYS I_COBJ# INDEX               07-feb-2006 22:10 SYS OBJ$ TABLE               07-feb-2006 22:52 SYS I_COL3 INDEX               07-feb-2006 22:10 SYS C_OBJ# CLUSTER             07-feb-2006 22:10 SYS TAB$ TABLE               07-feb-2006 22:38 SYS CDEF$ TABLE               07-feb-2006 22:38 SYS OWNER ------------------------------ OBJECT_NAME ---------------------------------------------------------------------------------------------------- OBJECT_TYPE         LAST_DDL_TIME ------------------- ----------------- I_CDEF1 INDEX               07-feb-2006 22:10 49 rows selected. SQL>