to_char中的第三个参数怎么把中文日期转换为英文
也就是to_char第三个参数怎么设置
也就是to_char第三个参数怎么设置
解决方案 »
- 列转换为行
- oracle 启动 不了的问题
- commit问题?
- 执行CREATE TABLE TEST_CLOB ( ID NUMBER(3), CLOBCOL CLOB)建一表出错
- sql 分组 添加组序号的问题 求教高手
- 求一ORACLE函数 知道表名,关键字,求某属性的值
- 请教 Oracle9i里边的 insert all into...在 8i中该怎么写
- jdbc 访问数据 当返回的是一个唯一值时候 获取方式
- 用sys用户怎么无法把一个用户的权限付给另外一个用户呢??
- PL/SQL Developer 连接不上,求助
- 如何写这样一条SQL语句
- Enterprise Manager 无法连接到数据库实例。下面列出了组件的状态。(在线等)
ual;TO_CHAR(SYSDAT
--------------
2008-dec-15
two thousand eight-december -tuesday
om dual;TO_CHAR(SYSDATE,'DDSPTH-MON-YEAR','NLS_DATE_LANGUAGE=AMERICAN')
----------------------------------------------------------------
sixteenth-dec-two thousand eight
这样的日期看着多不方便啊,好奇楼主的需求
这个很厉害。
to_char_date::=
Text description of to_char_date
Purpose
TO_CHAR (datetime) converts date of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH LOCAL TIME ZONE datatype to a value of VARCHAR2 datatype in the format specified by the date format fmt. If you omit fmt, then date is converted to a VARCHAR2 value as follows:DATE is converted to a value in the default date format.
TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE are converted to values in the default timestamp format.
TIMESTAMP WITH TIME ZONE is converted to a value in the default timestamp with time zone format.
The 'nlsparams' specifies the language in which month and day names and abbreviations are returned. This argument can have this form:'NLS_DATE_LANGUAGE = language'
TO_CHAR(SYSDATE,'YEAR-MONTH-DD
-----------------------------------------------------------------------
two thousand eight-december -seventeenth
TO_CHAR(SYSDATE,'YEAR-MON-DY',
--------------------------------------------------------
two thousand eight-dec-wed