TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi') : TO_CHAR « Conversion Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. TO_CHAR
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>








15.7.TO_CHAR
15.7.1.Format Parameters
15.7.2.TO_CHAR(x [, format]) converts x to a string.
15.7.3.TO_CHAR() will return a string of pound characters (#) if you try and format a number that contains too many digits for the format you have provided.
15.7.4.Use TO_CHAR() to convert columns containing numbers to strings.
15.7.5.TO_CHAR(12345.67, '99,999.99') (1)
15.7.6.TO_CHAR(12345.67, '99999.99') (2)
15.7.7.TO_CHAR(-12345.67, '99,999.99') (3)
15.7.8.TO_CHAR(12345.67, '099,999.99') (4)
15.7.9.TO_CHAR(12345.67, '99,999.9900')
15.7.10.TO_CHAR(12345.67, '$99,999.99')
15.7.11.TO_CHAR(0.67, 'B9.99')
15.7.12.TO_CHAR(12345.67, 'C99,999.99')
15.7.13.TO_CHAR(12345.67, '99999D99')
15.7.14.TO_CHAR(12345.67, '99999.99EEEE')
15.7.15.TO_CHAR(0012345.6700, 'FM99999.99')
15.7.16.TO_CHAR(12345.67, '99999G99')
15.7.17.TO_CHAR(12345.67, 'L99,999.99')
15.7.18.TO_CHAR(-12345.67, '99,999.99MI')
15.7.19.TO_CHAR(-12345.67, '99,999.99PR')
15.7.20.TO_CHAR(2007, 'RN')
15.7.21.TO_CHAR(12345.67, 'TM')
15.7.22.TO_CHAR(12345.67, 'U99,999.99')
15.7.23.TO_CHAR(12345.67, '99999V99')
15.7.24.TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi')
15.7.25.to_char(sysdate,'hh24:mi:ss') as time
15.7.26.to_char(to_date('01/01/2006','dd/mm/yyyy'),is on Day') as new_year_2006
15.7.27.to_char(sysdate, 'Day', 'nls_date_language=Dutch')
15.7.28.to_char(sysdate,'DAY dy Dy')
15.7.29.to_char(sysdate,'MONTH mon') as month
15.7.30.to_char(bdate,'fmMonth ddth, yyyy')
15.7.31.use to_char more than once to create long date format