有关NLS_DATE_FORMAT设置

最新推荐文章于 2024-03-08 17:50:14 发布

原创最新推荐文章于 2024-03-08 17:50:14 发布 · 220 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

Oracle字符集专栏收录该内容

8 篇文章

订阅专栏

本文解释了在Oracle环境中NLS_DATE_FORMAT的设置及其优先级。该格式用于确定日期显示方式，其设置取决于会话、客户端及实例级别的配置。文章详细介绍了不同场景下NLS_DATE_FORMAT的具体取值。

NLS_DATE_FORMAT is used if a date format mask is not specified in application code. The effective NLS_DATE_FORMAT is determined by the following (in order of precedence):

1. Session NLS_DATE_FORMAT (via ALTER SESSION command)
2. Client side NLS_DATE_FORMAT (from client environment variables/registry settings)
3. Instance NLS_DATE_FORMAT (from init.ora file)
4. Database NLS_DATE_FORMAT

Session NLS_DATE_FORMAT is set to client side NLS_DATE_FORMAT (explicit or implicit) ONLY if NLS_LANG is set. Another words, if NLS_LANG is set, then session NLS_DATE_FORMAT will be taken from the client. If clent NLS_LANG is set and client NLS_DATE_FORMAT is not, session NLS_DATE_FORMAT will default to DD-MON-YY (and that was exactly what you experienced). If NLS_LANG is not specified on the client side, NLS_DATE_FORMAT will be taken from instance NLS_DATE_FORMAT which is NLS_DATE_FORMAT from INIT.ORA. If NLS_DATE_FORMAT is not set in INIT.ORA, session NLS_DATE_FORMAT will default to DD-MON-YY.