日期格式转换（2种方法）

SQL> select to_char(sysdate, 'MON', 'NLS_DATE_LANGUAGE = American') from dual;

TO_CHA ------ JUL

SQL>

SQL> select extract(day from sysdate)||'-'||   2  decode(extract(month from sysdate),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6, 'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec')||'-'||extract(year from sysdate)  Calendar from dual;

CALENDAR -------------------------------------------------------------------------------- 4-Jul-2008

SQL>