title: SQL Date Formatting from String
body: <p>I am stuck trying to convert the following strings formatted like this <code>26-09-2021-02-54-03</code> (DD-MM-YYYY-hh-mm-ss) into timestamp or in this format YYYY-MM-DD HH:DD:SS in BigQuery. Any idea how to process?</p>
  <p>I cannot use <code>PARSE_TIMESTAMP()</code> since there is no T in the string.</p>
  <p>Thank you</p>