title: Apache NiFi: UpdateRecord processor retunrs java.lang.NumberFormatException error
body: <p>Asking a question, there is a problem while sending e-commerce information to BigQuery in a csv file. In csv, the value of the <code>ORDER_DATE</code> column should go into the <code>yyyy-MM-dd HH:mm:ss</code> format in the <code>DATETIME</code> type column in the BigQuery, tried to find some references on Google.</p>
  <h3>Environment</h3>
  <ul>
  <li>Apache NiFi 1.14.0 on Docker</li>
  </ul>
  <h3>Attempt1</h3>
  <p><strong>Replacement Value Strategy</strong> was selected to <strong>Literal Value</strong>, and<code>/ORDER_DATE</code> was added as a new field. The value is as follows:</p>
  <pre class="lang-java prettyprint-override"><code>${field.value:toDate('yyyyMMddhhmmss','GMT'):format('yyyy-MM-dd hh:mm:ss', 'GMT')}
  </code></pre>
  <p>Symptom is below:
  <a href="https://i.stack.imgur.com/FirdS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FirdS.png" alt="enter image description here" /></a></p>
  <h3>Attempt2</h3>
  <p>Found a new reference, that the NiFi expression was wrong, so I did another way:</p>
  <pre class="lang-java prettyprint-override"><code>${field.value:equals('0'):ifElse('', ${field.value:replace(${field.value},${field.value:toDate('yyyyMMddHHmmss'):format('yyyy-MM-dd HH:mm:ss'):toString()})})}
  </code></pre>
  <p>Likewise symptom is below:
  <a href="https://i.stack.imgur.com/88aGf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/88aGf.png" alt="enter image description here" /></a></p>
  <p>Someone asked me to open the log, checked and it's as follows:</p>
  <blockquote>
  <p>java.lang.NumberFormatException: For input string: &quot;2022-01-08 15:22:17&quot;</p>
  </blockquote>
  <p>Any ideas? Thank you :)</p>