title: how to resolve Error :ORA-01861: literal does not match format string
body: <p>I am writing query to convert string value of length 14 to date using below query </p>
  
  <pre><code> select to_date(strDate,'DD-MON-YY HH24:MI:SS') from TempTableExtra
  </code></pre>
  
  <p>But I am getting below error:</p>
  
  <pre><code>    ORA-01861: literal does not match format string
  01861. 00000 -  "literal does not match format string"
  *Cause:    Literals in the input must be the same length as literals in
             the format string (with the exception of leading whitespace).  If the
             "FX" modifier has been toggled on, the literal must match exactly,
             with no extra whitespace.
  *Action:   Correct the format string to match the literal.
  </code></pre>
  
  <p>The values for column "strDate" are as like below </p>
  
  <p><code>20161104083815
  20161104142227
  20170206150945
  20170206151122
  20170206151130
  20170306094206
  20170328105454
  </code></p>