title: How to convert date from field for comparison on WHEN-VALIDATE-ITEM trigger
body: <p>I'm working on Oracle Forms application. I have a field called <code>DOB</code> which has a date format of <code>08-May-1890</code>. I would like to convert it to <code>18900508</code> on <code>WHEN-VALIDATE-ITEM</code> trigger for comparison.</p>
  
  <p>I'm very new to this and have no idea where to start. Below is the code that I'm currently working with.</p>
  
  <pre><code>BEGIN
      --Convert date from 08-May-1890 to 1890508
      IF( TO_CHAR(:EMPLOYEE.DOB,'YYYY-MON-DD') &lt; 20180927)THEN
          --Do Something in here
          RAISE FORM_TRIGGER_FAILURE;
      END IF;
  END;
  </code></pre>