NLS_DATE_FORMAT
Parameter type | String |
Syntax | NLS_DATE_FORMAT = "format" |
Default value | Derived from NLS_TERRITORY |
Parameter class | Dynamic: ALTER SESSION |
Range of values | Any valid date format mask but not exceeding a fixed length |
NLS_DATE_FORMAT specifies the default date format to use with the TO_CHAR and TO_DATE functions. The default value of this parameter is determined by NLS_TERRITORY.
The value of this parameter can be any valid date format mask, and the value must be surrounded by double quotation marks. For example:
NLS_DATE_FORMAT = "MM/DD/YYYY"
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9078678/viewspace-45113/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
NLS_CURRENCY(转)
下一篇：
NLS_DATE_LANGUAGE(转)
请登录后发表评论
登录
全部评论
