oracle 时间格式的调整
程序员文章站
2023-11-12 17:04:46
select * from v$nls_parameters; sql> alter session set nls_date_language = 'simplif...
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>
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>