SQL>SQL> select trunc( sysdate ) 2 from dual 3 /TRUNC(SYSDATE)--------------------16-JUN-2008 00:00:001 row selected.SQL> --