SQL>SQL> -- Removing the time from SYSDATE.SQL>SQL> SELECT TO_CHAR(TRUNC(SYSDATE),'MM/DD/YYYY HH:MM:SS AM') "Today's Date and Time" from DUAL;Today's Date and Time----------------------08/31/2006 12:08:00 AMSQL>SQL>