Re: NLS_CALENDAR

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 31 Aug 1999 08:30:07 +0200
Message-ID: <7qfsqp$3hu$1@oceanite.cybercable.fr>

Many different calendar systems are in use throughout the world. NLS_CALENDAR specifies which calendar system Oracle uses.

NLS_CALENDAR can have one of the following values:

Arabic Hijrah
English Hijrah
Gregorian
Japanese Imperial
Persian
ROC Official (Republic of China)
Thai Buddha

For example, if NLS_CALENDAR is set to "Japanese Imperial", the date format is "E YY-MM-DD", and the date is May 15, 1997, then the SYSDATE is displayed as follows:

SELECT SYSDATE FROM DUAL;
SYSDATE

---

H 09-05-15

Kuncoro Tri Atmoko a écrit dans le message ...
>I've tried many use the command :
> ALTER SYSTEM SET NLS....
>
>But I stil confuse the using of
> ALTER SYSTEM SET NLS_CALENDAR
>
>Coz when I looking for the explanation in the Help,
>there's no detail explanation there.
>Is there anyone want to help me ?
>
>Kuncoro,
>Jakarta, Indonesia
>
>
Received on Tue Aug 31 1999 - 01:30:07 CDT