title: How to convert multiple string formats into one date format in BigQuery?
body: <p>I have a date column say "payment date" in my data which has multiple string formats such as <code>ddmmyyyy</code>,<code>ddmyyyy</code> and <code>yyyymmdd</code>. Does anyone know how I can convert all of these into a unified date format like <code>dd-mm-yyyy</code> in BigQuery?</p>