Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Truncates 7
SQL>  SELECT TO_CHAR(TRUNC(TO_DATE('25-MAY-2005 19:45:26',
  2    'DD-MON-YYYY HH24:MI:SS'), 'HH24'), 'DD-MON-YYYY HH24:MI:SS')
  3  FROM dual;
TO_CHAR(TRUNC(TO_DAT
--------------------
25-MAY-2005 19:00:00
SQL>