Numeric Math Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Numeric Math Functions
  4. Rounds 7
SQL>
SQL> SELECT TO_CHAR(ROUND(TO_DATE('25-MAY-2005 19:45:26','DD-MON-YYYY HH24:MI:SS
'), 'HH24'), 'DD-MON-YYYY HH24:MI:SS') FROM dual;
TO_CHAR(ROUND(TO_DAT
--------------------
25-MAY-2005 20:00:00
SQL>
SQL>
SQL>