NLS_DATE_LANGUAGE

Property	Description
Parameter type	String
Syntax	`NLS_DATE_LANGUAGE =` `language`
Default value	Derived from `NLS_LANGUAGE`
Modifiable	`ALTER SESSION`
Range of values	Any valid `NLS_LANGUAGE` value

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

See Also:

Oracle Database Globalization Support Guide for more information on setting this parameter
Oracle Database SQL Reference for information on the TO_DATE and TO_CHAR functions.
Oracle Database Heterogeneous Connectivity Administrator's Guide for information on setting this parameter in heterogeneous systems