Convert DD-Mon-YYYY to DD/MM/YYYY

Question

I need to convert dt_of_birth `[varchar] (15)` which is in the format `DD-Mon-YYYY` to `DD/MM/YYYY`. `dt_of _birth` is specified in different table and the conversion had to be done and stored in another table which has the same column name as `dt_of_birth`.

Accepted Answer

Here

```
SELECT convert(datetime, '23/10/2016', 103) -- dd/mm/yyyy
```

Convert DD-Mon-YYYY to DD/MM/YYYY

Solution

Problem