Sometimes you want to get a date format to a locale which is different than your current SQL Server machine. For example, I have a Japanese SQL Server Machine, but I want to return the date format in US English settings.
What I did was to use the command: SET LANGUAGE [locale]