Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 103 of 188


NLS_CALENDAR

Parameter type: 

String 

Syntax: 

NLS_CALENDAR = "calendar_system" 

Parameter class: 

Dynamic. Scope = ALTER SESSION. 

Default value: 

None 

Range of values: 

Any valid calendar format name 

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

  • Arabic Hijrah

  • English Hijrah

  • Gregorian

  • Japanese Imperial

  • Persian

  • ROC Official (Republic of China)

  • Thai Buddha

 

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: Oracle8i National Language Support Guide for a listing of available calendar systems.  


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index