oracle 时间格式的调整

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>