M / D / YYYY h：mm tt到DATETIME SQL Server

I'm trying to convert string date into a datetime datatype in sql server. This question was asked in a different forum however my situation is a bit different These are the possibilities of string date I'm trying to convert string date into a dateti