Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 112 of 220
Parameter type |
String |
Syntax |
|
Default value |
None |
Parameter class |
Dynamic: |
Range of values |
Any valid calendar format name |
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
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|