title: How to display time only
body: <p><a href="https://i.stack.imgur.com/7ANyl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7ANyl.jpg" alt="enter image description here"></a>Can anyone help me how can I change the output of <code>Time_done</code> to a time only (example: 5:00AM)? If I add <code>TO_CHAR(SYSDATE, 'HH24:MI:SS')</code> on <code>SYSDATE</code>, I got an error message </p>
  
  <blockquote>
    <p>ORA-01843: not a valid month.</p>
  </blockquote>
  
  <p>Below are my codes and screen capture of <code>EVENTLOGS</code> table</p>
  
  <pre><code>   CREATE TABLE EVENTLOGS(
          Eventlog_id   Number(3,0)   NOT NULL,
          User_name     Varchar2(20),
          Date_done     Date,
          Time_done     Timestamp,
          Action_done   Varchar2(50),
      CONSTRAINT PK_EVENTLOGS PRIMARY KEY (Eventlog_id));
  
  /*  TRIGGER CREATION  */
  CREATE OR REPLACE TRIGGER SUPERHEROES_AUDIT
  AFTER INSERT OR DELETE OR UPDATE ON SUPERHEROES
  FOR EACH ROW
  ENABLE
  DECLARE
    V_LOGID NUMBER;
    V_USER  VARCHAR(30);
    V_DATE  DATE;
  
  BEGIN
    SELECT EVENTLOG_ID_SEQ.NEXTVAL, USER INTO V_LOGID, V_USER FROM DUAL;
    IF INSERTING THEN
      INSERT INTO EVENTLOGS(Eventlog_id, User_name, Date_done, Time_done, Action_done)
      VALUES (V_LOGID, V_USER, SYSDATE, SYSDATE, 'INSERT');
    ELSIF DELETING THEN
      INSERT INTO EVENTLOGS(Eventlog_id, User_name, Date_done, Action_done)
      VALUES (V_LOGID, V_USER, V_DATE, SYSDATE, SYSDATE, 'DELETE');
    ELSIF UPDATING THEN
      INSERT INTO EVENTLOGS(Eventlog_id, User_name, Date_done, Action_done)
      VALUES (V_LOGID, V_USER, V_DATE, SYSDATE, SYSDATE, 'UPDATE');
    END IF;
  END;
  /
  
  [![INSERT INTO 
  EMPLOYEE_T (EmployeeID, EmployeeName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZip, EmployeeBirthDate, EmployeeDateHired, EmployeeSupervisor)
  VALUES (2, 'JACKIE', 'AFRICA', 'kenya', 'NO', 11285, TO_DATE('13-OCT-1950', 'DD-MM-YYYY'), TO_DATE('27-JUN-2014', 'DD-MM-YYYY'), 455789);][1]][1]
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Scvyj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Scvyj.png" alt="enter image description here"></a></p>