title: ORA-01830: date format picture ends before converting entire input string
body: <p>The SQL works fine on most installations.  However I'm having a problem with an Oracle installation in Canada (possible date localization issue?).</p>
  
  <p><a href="http://www.google.com/search?q=ORA-01830" rel="nofollow noreferrer">http://www.google.com/search?q=ORA-01830</a></p>
  
  <p>I'm feeding data to a proprietary processor that generates the SQL.  I only provide data.  I was hoping for information that may help me solve it without involving support from the processor.</p>