converting text to dattime

Question

if I have a text string like

01Jan1970

to ta datetime like 1970-01-01 00:00:00.00

Answer 1

SELECT CONVERT(datetime, '01Jan1970' , 120)

---

Known is a DROP, Unknown is an OCEAN.

Answer 2

thanks Bangaaram!