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.