background image
<< Setting Calendar Definitions | Using Numeric Formats >>
<< Setting Calendar Definitions | Using Numeric Formats >>

Using the NLS_CALENDAR Parameter

Establishing a Globalization Support Environment
6-16 Oracle Database 2 Day Developer's Guide
The first calendar week of the year is determined by the
NLS_TERRITORY
parameter.
Number of Days and Months in a Year
: Oracle supports six calendar systems in
addition to the Gregorian calendar, which is the default. These additional calendar
systems are:
Japanese Imperial uses the same number of months and days as the Gregorian
calendar, but the year starts with the beginning of each Imperial Era.
ROC Official uses the same number of months and days as the Gregorian
calendar, but the year starts with the founding of the Republic of China.
Persian has 31 days for each of the first 6 months. The next 5 months have 30
days each. The last month has either 29 days or 30 days (leap year).
Thai Buddha uses a Buddhist calendar.
Arabic Hijrah has 12 months and 354 or 355 days.
English Hijrah has 12 months and 354 or 355 days.
The calendar system is specified by the
NLS_CALENDAR
parameter.
First Year of Era
: The Islamic calendar starts from the year of the Hegira. The
Japanese Imperial calendar starts from the beginning of an Emperor's reign. For
example, 1998 is the tenth year of the Heisei era.
Using the NLS_CALENDAR Parameter
Many different calendar systems are in use throughout the world. The
NLS_CALENDAR
parameter specifies which calendar system Oracle Database uses. The default value is
Gregorian
. The value can be any valid calendar format name.
The
NLS_CALENDAR
parameter can have one of the following values:
Arabic Hijrah
English Hijrah
Gregorian
Japanese Imperial
Persian
ROC Official (Republic of China)
Thai Buddha
To set the NLS_CALENDAR parameter:
The following example sets the NLS_CALENDAR value to English Hijrah, and it
displays the value for the first day of Ramadan in the year 1424 H. The other NLS
parameters reflect the default SQL Developer settings.
1.
In SQL Developer, make a note of the current calendar format in which Oracle
Database was installed.
See Also:
Using the NLS_CALENDAR Parameter
on page 6-16
Oracle Database Globalization Support Guide for locale information,
including supported calendars