NLS_DATE_LANGUAGE
The NLS_DATE_LANGUAGE option specifies the language for days, months, and similar language-dependent datetime format elements.
Within a session, you can dynamically modify the value of this option using the OLAP DML syntax show below or by using the SQL statement ALTER SESSION SET option = value.
Syntax
NLS_DATE_LANGUAGE = option-value
Examples
Example 5-74 Setting the Language for Dates
The following statements set the language for dates to Spanish and change the default date format.
NLS_DATE_LANGUAGE = 'SPANISH'
NLS_DATE_FORMAT = 'Month DD, YYYY'
A SHOW SYSDATE statement now generates the date in Spanish.
Septiembre 08, 2000
