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.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘NLS_DATE_LANGUAGE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
nls_date_language		TRUE	TRUE	FALSE	FALSE	FALSE	NLS date language name

Oracle initializatoin parameters