SQL Server date formatting from string

We’ve recently migrated our database to a different server & since this I think the date format querying has changed somehow.

Previously we could use the following..

However now we have to use..

Can someone tell me what I need to alter to obtain back to the previous version?

Try this one –


Read current settings: