title: How to enter in DateTime in Oracle
body: <p>Some scope creep occured in the last couple of days and now I have to squeeze in date time.  The Oracle stored procedure has a Date field (same with the table).  Every time I try to enter in the date time value I get this refrain from the exception thrower:</p>
  
  <pre><code>ORA-01830: date format picture ends before converting entire input string
  ORA-06512: at line 56
  </code></pre>
  
  <p>Here is what I try to enter:</p>
  
  <pre><code>SPECIALIST_APPT_DATETIMEIN := '09/Sep/1990 00:00:00'
  </code></pre>
  
  <p>Here is the param definition I try to squeeze it into:</p>
  
  <pre><code>PCP_APPOINTMENT_DATETIME`in `DATE`
  </code></pre>