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>