oracle 时间格式的调整
摘要:select*fromV$NLS_PARAMETERS;SQL>altersessionsetNLS_DATE_LANGUAGE='SIMP...
select * from V$NLS_PARAMETERS;
SQL> alter session set NLS_DATE_LANGUAGE = 'SIMPLIFIED CHINESE';
Session altered
SQL> Select to_char(sysdate,'yyyy-Mon-day') from dual;
TO_CHAR(SYSDATE,'YYYY-MON-DAY'
------------------------------
2009-5月 -星期三
SQL> alter session set NLS_DATE_LANGUAGE='AMERICAN';
Session altered
SQL> Select to_char(sysdate,'yyyy-Mon-day') from dual;
TO_CHAR(SYSDATE,'YYYY-MON-DAY'
------------------------------
2009-May-wednesday
SQL>
【oracle 时间格式的调整】相关文章:
★ Oracle索引
上一篇:
Oracle 触发器的使用小结