Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Removing the Time from SYSDATE

SQL> SQL> SELECT TO_CHAR(TRUNC(SYSDATE),'MM/DD/YYYY HH:MM:SS AM')   2      "Today's Date and Time"   3       from DUAL; Today's Date and Time ---------------------- 06/16/2008 12:06:00 AM 1 row selected. SQL> --