Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Trunc a date

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