Oracle PL/SQL Date Timestamp Functions :Date Functions

We must format dates to see all of the information contained in a date column.

We use the TO_CHAR function to do the converting.

SQL> SELECT SYSDATE FROM dual; SYSDATE --------- 01-APR-11 SQL>

SQL> SELECT TO_CHAR(SYSDATE, 'ddMONyyyy') Today   2  FROM dual; TODAY --------- 01APR2011 SQL>