title: Inserting Date gives error ORA-01861: literal does not match format string
body: <p>Insert date into WSH_Delivery_Details_Interface (<a href="https://docs.oracle.com/cloud/r13_update17c/scmcs_gs/OEDSC/WSH_DELIVERY_DETAILS_tbl.htm" rel="nofollow noreferrer">https://docs.oracle.com/cloud/r13_update17c/scmcs_gs/OEDSC/WSH_DELIVERY_DETAILS_tbl.htm</a>) throws this error </p>
  
  <p>Query : </p>
  
  <pre><code>insert into WSH_DEL_DETAILS_Interface
      (DELIVERY_DETAIL_INTERFACE_ID, CREATION_DATE, Date_Requested)
  values
      (30010985553,
       TO_DATE('11/12/2018T05:10:30-00:00', 'DD/MM/YYYY '),
       TO_DATE('11/12/2018', 'DD/MM/YYYY'));
  </code></pre>
  
  <p><strong>Sample Record in creation_date and date_requested column:</strong></p>
  
  <pre><code>Date_Requested    Creation_Date
  16-JUN-10         17-JUN-10 03.40.31.865000000 PM
  </code></pre>