nls_date_format | OceanBase 文档中心

文档反馈

分布式版-V4.0.0社区版

文档概览
简介
快速上手
应用开发
部署数据库
管理数据库
数据迁移
参考指南
- 系统架构
- SQL 语句
- 系统视图
- 系统变量
  - 系统变量概述
  - 系统变量总览
  - auto_increment_cache_size
  - auto_increment_increment
  - auto_increment_offset
  - autocommit
  - binlog_row_image
  - block_encryption_mode
  - character_set_client
  - character_set_connection
  - character_set_database
  - character_set_filesystem
  - character_set_results
  - character_set_server
  - character_set_system
  - collation_connection
  - collation_database
  - collation_server
  - connect_timeout
  - cursor_sharing
  - datadir
  - debug_sync
  - default_password_lifetime
  - div_precision_increment
  - error_on_overlap_time
  - explicit_defaults_for_timestamp
  - foreign_key_checks
  - group_concat_max_len
  - identity
  - init_connect
  - innodb_strict_mode
  - interactive_timeout
  - is_result_accurate
  - last_insert_id
  - license
  - lower_case_table_names
  - max_allowed_packet
  - max_connections
  - max_sp_recursion_depth
  - max_user_connections
  - net_buffer_length
  - net_read_timeout
  - net_write_timeout
  - nls_calendar
  - nls_characterset
  - nls_comp
  - nls_currency
  - nls_date_format
  - nls_date_language
  - nls_dual_currency
  - nls_iso_currency
  - nls_language
  - nls_length_semantics
  - nls_nchar_characterset
  - nls_nchar_conv_excp
  - nls_numeric_characters
  - nls_sort
  - nls_territory
  - nls_timestamp_format
  - nls_timestamp_tz_format
  - ob_bnl_join_cache_size
  - ob_capability_flag
  - ob_compatibility_mode
  - ob_early_lock_release
  - ob_enable_aggregation_pushdown
  - ob_enable_index_direct_select
  - ob_enable_jit
  - ob_enable_plan_cache
  - ob_enable_sql_audit
  - ob_enable_show_trace
  - ob_enable_transformation
  - ob_enable_transmission_checksum
  - ob_enable_truncate_flashback
  - ob_global_debug_sync
  - ob_last_schema_version
  - ob_log_level
  - ob_org_cluster_id
  - ob_pl_block_timeout
  - ob_plan_cache_evict_high_percentage
  - ob_plan_cache_evict_low_percentage
  - ob_plan_cache_percentage
  - ob_proxy_global_variables_version
  - ob_proxy_partition_hit
  - ob_proxy_set_trx_executed
  - ob_query_timeout
  - ob_read_consistency
  - ob_reserved_meta_memory_percentage
  - ob_route_policy
  - ob_sql_audit_percentage
  - ob_sql_work_area_percentage
  - ob_tcp_invited_nodes
  - ob_temp_tablespace_size_percentage
  - ob_trace_info
  - ob_trx_idle_timeout
  - ob_trx_lock_timeout
  - ob_trx_timeout
  - optimizer_capture_sql_plan_baselines
  - optimizer_use_sql_plan_baselines
  - parallel_max_servers
  - parallel_servers_target
  - performance_schema
  - plugin_dir
  - query_cache_size
  - query_cache_type
  - read_only
  - recyclebin
  - resource_manager_plan
  - secure_file_priv
  - sql_auto_is_null
  - sql_mode
  - sql_quote_show_create
  - sql_safe_updates
  - sql_select_limit
  - sql_throttle_current_priority
  - sql_throttle_network
  - sql_throttle_priority
  - sql_throttle_rt
  - sql_warnings
  - system_time_zone
  - time_zone
  - timestamp
  - tracefile_identifier
  - transaction_isolation
  - transaction_read_only
  - tx_isolation
  - tx_read_only
  - version
  - version_comment
  - wait_timeout
  - validate_password_check_user_name
  - validate_password_length
  - validate_password_mixed_case_count
  - validate_password_number_count
  - validate_password_policy
  - validate_password_special_char_count
  - server_uuid
  - default_storage_engine
  - ob_enable_rich_error_msg
- 系统配置项
- 错误码
- 预留关键字
- 生态工具
快速入门系列教程
版本发布记录
术语

nls_date_format

更新时间：2026-06-23 11:07:59

分享

nls_date_format 用于控制 date 类型转 str 的格式，以及 str 隐式转 date 的格式。

说明

该变量当前暂不生效。

属性	描述
参数类型	varchar
默认值	DD-MON-RR
取值范围	N/A
生效范围	Global Session
是否参与序列化	是

有帮助

无帮助