String 

NLS_DATE_LANGUAGE = language 

Dynamic. Scope = ALTER SESSION. 

Derived from NLS_LANGUAGE 

Any valid NLS_LANGUAGE value 

NLS_DATE_LANGUAGE specifies the language to use for the spelling of day and month names and date abbreviations (AM, PM, AD, BC) returned by the TO_DATE and TO_CHAR functions.

See Also:

• Oracle8i National Language Support Guide for more information on setting this parameter.

• Oracle8i SQL Reference for information on the TO_DATE and TO_CHAR functions.

• Oracle8i Distributed Database Systems for information on setting this parameter in heterogeneous systems.