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