Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / 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 --------- 29-MAY-07 SQL> SQL> SELECT TO_CHAR(SYSDATE, 'ddMONyyyy') Today   2  FROM dual; TODAY --------- 29MAY2007 SQL>