Oracle nls_date_language 不同国家语言

nls_date_language = 语言名
这个语言名的大小写还会决定输出内容的大小写：
首字母大写，English会输出Wednesday
全大写， ENGLISH会输出WENDNESDAY
全小写，english会输出wednesday；
改变语言名就可以输出不同语言。
select ‘see you on ‘||to_char(sysdate+2,‘Day’)||’!’ from dual;
–see you on 星期三!
select ‘see you on ‘||to_char(sysdate+2,‘Day’,‘nls_date_language = american’)||’!’ from dual;
–see you on Wednesday!
select ‘see you on ‘||to_char(sysdate+2,‘Day’,‘nls_date_language = japanese’)||’!’ from dual;
–see you on 水曜日!
select ‘see you on ‘||to_char(sysdate+2,‘Day’,‘nls_date_language = russian’)||’!’ from dual;
–see you on Среда !
select ‘see you on ‘||to_char(sysdate+2,‘Day’,‘nls_date_language = korean’)||’!’ from dual;
–see you on 수요일!
select ‘see you on ‘||to_char(sysdate+2,‘Day’,‘nls_date_language = danish’)||’!’ from dual;
–丹麦语 see you on Onsdag !
select ‘see you on ‘||to_char(sysdate+2,‘Day’,‘nls_date_language = czech’)||’!’ from dual;
–捷克语 see you on Středa !