Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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> --