title: timstamp from string to timestamp in BigQuery
body: <p>i have the followoing format of a timestamp which is saved as string.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>2022-09-15T11:07:28.872</code></pre>
  </div>
  </div>
  </p>
  <p>I've tried to convert it to timestamp like this</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>PARSE_TIMESTAMP("%Y-%m-%d-%H:%M:%S",JSON_VALUE(DATA,'$.payload.onHoldUntil'))</code></pre>
  </div>
  </div>
  </p>
  <p>but i get the following error</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>Mismatch between format character '-' and string character 'T'</code></pre>
  </div>
  </div>
  </p>
  <p>How can i solve this issue ?</p>