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.

Answer 1

Here

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

Answer 2

This will work

SELECT CONVERT(CHAR(11), CONVERT(SMALLDATETIME, '27-Jan-2011', 13), 103);