Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. TO_CHAR(sysdate,HH24
SQL>
SQL> select TO_CHAR(sysdate,'HH24:MI:SS') from dual;
TO_CHAR(
--------
19:26:37