title: Add two hours to timestamp
body: <p>I've got a trigger that has to set a timestamp to the current time plus two hours when the field is null before insert. One of the statements I tried so far is</p>
  
  <pre><code>IF :new.time_to_live IS NULL THEN
      :new.time_to_live := sysdate + INTERVAL '0 02:00:00.0' HOUR TO MINUTE;
  END IF;
  </code></pre>
  
  <p>but I get a PLS-00166 Error (bad format for date, time, timestamp or interval literal) for the second row. Also modified it to several suggestions in multiple forums but the error stays. The column is created as follows:</p>
  
  <pre><code>time_to_live timestamp(0) NOT NULL
  </code></pre>