to_char()将日期转为字符串:
select to_char(sysdate,'yyyyMMdd') from dual;
to_date()将字符串转为日期:
select to_date('20150917','yyyyMMdd') from dual;
to_char()将日期转为字符串:
select to_char(sysdate,'yyyyMMdd') from dual;
to_date()将字符串转为日期:
select to_date('20150917','yyyyMMdd') from dual;