Open SSMS, and try this
SET LANGUAGE SPANISH;
SELECT GETDATE()
DBCC USEROPTIONS
SET LANGUAGE 'us_english';
SELECT GETDATE()
DBCC USEROPTIONS
Update
SET LANGUAGE
Quote:
Specifies the language environment for the session. The session language determines the datetime formats and system messages.
The Datetime data is stored as binary...