title: Converting different date formats to single one in SQL Server
body: <p>One of the STRING column of my table has both date formats "mm-dd-yyyy" and "yyyy-mm-dd". While selecting data I am trying to cast it to DATE format but it is giving me conversion error. I think this is because SQL can not convert 2 different formats at a time. How can I achieve this to get both formats converted to DATE in one go. </p>