SET LANGUAGE

Specifies the language environment for the session. The session language determines the datetime formats and system messages.
SET LANGUAGE implicitly sets the setting of SET DATEFORMAT.
Use
SET LANGUAGE ‘british english’
or
SET LANGUAGE us_english
to specify the language environment for the current session.