I need to convert dates of birth from type varchar into date.
The table is called "customer" and the column is called "date\_of\_birth".

The Column has entries where the format of the date is dd.MM.YYYY and dd/MM/YYYY and I want to change every entry of the column.

The code I have right now is:

```
ALTER COLUMN date_of_birth type date USING to_date(date_of_birth, 'dd.MM.YYYY');

```

This code would work if the existing entries would all have the format "dd.MM.YYYY. Can someone help me adding the last piece of code, which also uses the other date format that I've mentioned above (dd/MM/YYYY).

I thank you for your time!