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