Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

NLS_CALENDAR

Property Description
Parameter type String
Syntax NLS_CALENDAR = "calendar_system"
Default value None
Modifiable ALTER SESSION
Range of values Any valid calendar format name
Basic No

NLS_CALENDAR specifies which calendar system Oracle uses. It can have one of the following values:

For example, suppose NLS_CALENDAR is set to "Japanese Imperial", the date format is "E YY-MM-DD". ("E" is the date format element for the abbreviated era name.) If the date is May 15, 1997, then the SYSDATE is displayed as follows:

SELECT SYSDATE FROM DUAL;
SYSDATE
--------
H 09-05-15

See Also:

Oracle Database Globalization Support Guide for a listing of available calendar systems