NLS_DATE_LANGUAGE
来源:互联网 发布:p2p网络借贷的起源 编辑:程序博客网 时间:2024/05/21 08:40
导读:
The NLS_DATE_LANGUAGE option specifies the language for days, months, and similar language-dependent datetime format elements.
Within a session, you can dynamically modify the value of this option using the OLAP DML syntax show below or by using the SQL statement ALTER SESSIONSEToption=value.
Data Type
TEXT
Syntax
NLS_DATE_LANGUAGE = option-value
Arguments
See for more information about NLS parameters, including valid values.
Examples
Example 6-74 Setting the Language for Dates
The following statements set the language for dates to Spanish and change the default date format.
NLS_DATE_LANGUAGE = 'SPANISH'
NLS_DATE_FORMAT = 'Month DD, YYYY'
A SHOW SYSDATEstatement now generates the date in Spanish.
Septiembre 08, 2000
本文转自
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_options067.htm
The NLS_DATE_LANGUAGE option specifies the language for days, months, and similar language-dependent datetime format elements.
Within a session, you can dynamically modify the value of this option using the OLAP DML syntax show below or by using the SQL statement ALTER SESSIONSEToption=value.
Data Type
TEXT
Syntax
NLS_DATE_LANGUAGE = option-value
Arguments
See for more information about NLS parameters, including valid values.
Examples
Example 6-74 Setting the Language for Dates
The following statements set the language for dates to Spanish and change the default date format.
NLS_DATE_LANGUAGE = 'SPANISH'
NLS_DATE_FORMAT = 'Month DD, YYYY'
A SHOW SYSDATEstatement now generates the date in Spanish.
Septiembre 08, 2000
本文转自
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_options067.htm
- NLS_DATE_LANGUAGE
- nls_date_language
- 一个参数 nls_date_language
- 不同系统之间时间转换(NLS_DATE_LANGUAGE )
- 在数据库中NLS_DATE_LANGUAGE语句中的NLS是什么?
- java程序发布之jre篇
- 数据库主键设计之思考
- [.NET][C#]dotNet使用WSE3.0调用java的web服务
- 25年DBA讲述数据库管理的"瑞士军刀"
- WebGIS开发--滑铁卢(草草谢幕啦)
- NLS_DATE_LANGUAGE
- DNS,二级域名泛解析
- POSIX Threads for Windows – REFERENCE
- 精简出最小 jre
- Postgresql 客户端连接问题
- CAS 客户端配置
- Setup Organization Hierachy in Oracle EBS 11i or R12
- c#中ExecuteReader ExecuteNonQuery ExecuteScalar ExecuteXmlReader的区别
- 一名数据库从业者的三年回首:我与数据库