Initialization Parameters, 117 of 222

NLS_DATE_LANGUAGE

Parameter type	String
Syntax	`NLS_DATE_LANGUAGE =` `language`
Default value	Derived from `NLS_LANGUAGE`
Parameter class	Dynamic: `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:

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