系统日期转为英文格式oracle:?select to_char(sysdate, dd-mon-yyyy, nls_date_languageamerican) fr
系统日期转为英文格式
oracle:
?select to_char(sysdate, 'dd-mon-yyyy', 'nls_date_language=american') from dual;
结果::
04-nov-2011
?
?
?select to_char(sysdate, 'dd-Mon-yyyy', 'nls_date_language=american') from dual;
结果::
04-Nov-2011