I have a problem with changing default Date format. I changed the language to British English on server. I added new user and set British English as default language for him, but date is still showing in format ymd.
I want all dates in all databases to be in format dmy as default. I have tried this both on SQL Server Express 2014 edition and 2016 edition, but all dates are still in old English format (ymd).