Sometimes, string-to-date conversion in SQL Server results in an error, not because of the date or time formats used, but because you’re attempting to store incorrect information that’s not acceptable ...

-- The CONVERT () and TRY_CONVERT () functions can convert United States datetime format (month, day, year and time) -- by default, therefore, you don’t need to specify style 101 ...