Feb-2021转化为日期类型
select TO_DATE('01-' || 'Feb-2021','DD MONTH YYYY','NLS_DATE_LANGUAGE = American') from dual; --日期类型:2021-02-01
2021-02-01转化为Feb-2021类型
select to_char(trunc(to_date('2021-02-01','yyyy-mm-dd')),'DD-mon-yyyy','NLS_DATE_LANGUAGE = American') from dual;输出:01-feb-2021