sql server中单列中的不同日期格式

I am using SQL server. We have date column in table but some of them are stored in different format. column in t