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博客 ” ，链接：https://blog.itpub.net/9078678/viewspace-45110/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
NLS_COMP(转)
请登录后发表评论
登录
全部评论
