From Google Translate

Is it possible to update values based on wildcards? For example, I have many days in the database formatted with different criteria and I want them...

Th order of the tables only matters on the joins.  In other words, you cannot join to an object that has not yet been used higher up in the list...

For more information on the CONVERT function, take a look at the "Date and Time Styles" section of the Microsoft Docs

I suspect that the question is more along the lines of ....

Which is better?

SELECT ...
FROM TableA AS a
JOIN TableB AS b ON...