Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_globalization005.htm

Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_globalization005.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<script src="./callback.js" type="text/javascript"></script>
<noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript>
</head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />

<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" />
<meta name="date" content="2009-04-21T9:46:25Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="About Calendar Formats" />
<meta name="relnum" content="11g Release 2 (11.2)" />
<meta name="partnum" content="E10766-01" />
<link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
<link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
<link rel="contents" href="toc.htm" title="Contents" type="text/html" />
<link rel="prev" href="tdddg_globalization004.htm" title="Previous" type="text/html" />
<link rel="next" href="tdddg_globalization006.htm" title="Next" type="text/html" />
<title>About Calendar Formats</title>
</head>
<body>
<div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div>
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr valign="bottom">
<td align="left"></td>
<td align="center"><a href="tdddg_globalization004.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br />
<span class="icon">Previous</span></a>&nbsp;</td>
<td align="center"><a href="tdddg_globalization006.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br />
<span class="icon">Next</span></a></td>
</tr>
</table>
<p><a id="CACHAAJD" name="CACHAAJD"></a><a id="TDDDG62510" name="TDDDG62510"></a></p>
<div class="sect2">
<h1>About Calendar Formats</h1>
<a name="BEGIN" id="BEGIN"></a><a id="i1007204" name="i1007204"></a>
<p><a id="sthref625" name="sthref625"></a><a id="sthref626" name="sthref626"></a>Oracle Database stores this calendar information for each territory:</p>
<ul>
<li><a id="i1007222" name="i1007222"></a>
<p><span class="bold">First day of the week</span></p>
<p>Sunday in some cultures, Monday in others. Set by the <code>NLS_TERRITORY</code> parameter.</p>
</li>
<li><a id="i1007355" name="i1007355"></a>
<p><span class="bold">First week of the calendar year</span></p>
<p>Some countries use week numbers for scheduling, planning, and bookkeeping. In the ISO standard, this week number can differ from the week number of the calendar year. For example, 1st Jan 2005 is in ISO week number 53 of 2004. An ISO week starts on Monday and ends on Sunday. To support the ISO standard, Oracle Database provides the <a id="sthref627" name="sthref627"></a>IW date format element, which returns the ISO week number. The first calendar week of the year is set by the <code>NLS_TERRITORY</code> parameter.</p>
</li>
<li><a id="i1007619" name="i1007619"></a>
<p><span class="bold">Number of days and months in a year</span></p>
<p>Oracle Database supports six calendar systems in addition to the Gregorian calendar, which is the default. These additional calendar systems are:</p>
<ul>
<li>
<p>Japanese Imperial</p>
<p>Has the same number of months and days as the Gregorian calendar, but the year starts with the beginning of each Imperial Era.</p>
</li>
<li>
<p>ROC Official</p>
<p>Has the same number of months and days as the Gregorian calendar, but the year starts with the founding of the Republic of China.</p>
</li>
<li>
<p>Persian</p>
<p>The first six months have 31 days each, the next five months have 30 days each, and the last month has either 29 days or (in leap year) 30 days.</p>
</li>
<li>
<p>Thai Buddha uses a Buddhist calendar.</p>
</li>
<li>
<p>Arabic Hijrah has 12 months and 354 or 355 days.</p>
</li>
<li>
<p>English Hijrah has 12 months and 354 or 355 days.</p>
</li>
</ul>
<p>The calendar system is specified by the <code>NLS_CALENDAR</code> parameter.</p>
</li>
<li><a id="i1007640" name="i1007640"></a>
<p><span class="bold">First year of era</span></p>
<p>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).</p>
</li>
</ul>
<div class="helpinfonotealso">
<h2>Related Topics</h2>
<p><a href="tdddg_globalization018.htm#CACJBHAH">About the NLS_TERRITORY Parameter</a></p>
<p><a href="tdddg_globalization022.htm#CACGDEAF">About the NLS_CALENDAR Parameter</a></p>
<p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=NLSPG210','newWindow').focus()"><span class="italic">Oracle Database Globalization Support Guide</span></a></p>
<p><a href="tdddg_globalization001.htm#CACBGCDE">About Globalization Support Features</a></p>
</div>
</div>


<div class="footer">
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr>
<td align="left"><span class="copyrightlogo">Copyright&nbsp;&copy;&nbsp;1996, 2009,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span><br />
<a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td>
<td align="center"><a href="tdddg_globalization004.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br />
<span class="icon">Previous</span></a>&nbsp;</td>
<td align="center"><a href="tdddg_globalization006.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br />
<span class="icon">Next</span></a></td>
</tr>
</table>
</div>

</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de