I saw this answer from another post about converting DD–MMM-YY to YYYY-MM-DD in BigQuery using the combination of format_date and parse_date:
SELECT FORMAT_DATE("%Y/%m/%d",PARSE_DATE('%d-%b-%y','31-OCT-20'))
You can follow the format above if you are using Big Query, just change the date value.