title: Oracle ORA-01861: literal does not match format string
body: <p>I Can see that this has been asked before but there solution doesnt work. 
  '2017-08-31' is throwing an error. What should iot be?</p>
  
  <pre><code> AND TL.TL_PRCS_DATE BETWEEN TO_DATE(TO_CHAR('2017-08-31', 'YYYYMM') || '01', 'YYYYMMDD') AND '2017-08-31'
  </code></pre>