ITPub博客

首页 > Linux操作系统 > Linux操作系统 > NLS_CALENDAR(转)

NLS_CALENDAR(转)

原创 Linux操作系统 作者:tochar 时间:2007-07-26 00:00:00 0 删除 编辑

NLS_CALENDAR

Parameter type

String

Syntax

NLS_CALENDAR = "calendar_system"

Default value

None

Parameter class

Dynamic: ALTER SESSION

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9078678/viewspace-45110/,如需转载,请注明出处,否则将追究法律责任。

下一篇: NLS_COMP(转)
请登录后发表评论 登录
全部评论

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    788465