So I have a couple date fields in a table that are formatted as `(DD-MON-YYYY)` and I need to convert them to `(DD-MM-YYYY)` The field itself is already a `VARCHAR`. In Snowflake, how would I make this change. Here is what I have done so far.

`select to_date(end_date, 'dd-mm-yyyy') from` 

`error: Can't parse '31-JAN-2020' as date with format 'dd-mm-yyyy'`