I've got a SQL Server DB where it looks at dates as "MM/dd/yyyy" (i.e American style) and I want it to be the European style ("dd/MM/yyyy") - I remember there is some command that would do that, but can't remember which one.
The way a date is formatted in client applications like SQL Server Management Studio depends on the user's (login) settings.
Just select the login's language.
Dates and times are stored internally independent of the Culture or language settings. So there is no conversion necessary.
"Styling" your dates is in the responsibility of your programming language and should be done there.
And putting and getting dates into/from the database is possible with these tricks: