title: Oracle date format picture ends before converting entire input string
body: <p>My table has two DATE format attributes, however, when i try to insert value it throws an error: <strong>date format picture ends before converting entire input string.</strong>
  Here is my attempted code:</p>
  
  <pre><code>insert into visit
  values(123456, '19-JUN-13', '13-AUG-13 12:56 A.M.');
  </code></pre>
  
  <p>I think the problem is with <code>12:56</code> but Oracle documentation says <code>date</code> implies both date and time.</p>