系统日期转为英文格式

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