17,377
社区成员
发帖
与我相关
我的任务
分享
select to_char(last_day(sysdate),'yyyy-mm-dd','nls_date_language=american') from dual
select to_char(last_day(sysdate),'yyyy-mm-dd') from dual
select to_char(sysdate,'day','nls_date_language="simplified chinese"') from dual;
select to_char(sysdate,'day','nls_date_language='simplified chinese'') from dual;
正确
select to_char(sysdate,'day','nls_date_language=''simplified chinese''') from dual;
很变态诶,.[/quote]
用两个单引号的原因是,前面一个是转义字符。 ''转义的结果是 '
select to_char(sysdate,'day','nls_date_language="simplified chinese"') from dual;
select to_char(sysdate,'day','nls_date_language='simplified chinese'') from dual;
正确
select to_char(sysdate,'day','nls_date_language=''simplified chinese''') from dual;
很变态诶,.