1.to_char函数将日期转换成字符
select to_char(sysdate,'yyyy-mm-dd') from emp
2.to_date函数将字符装成日期
select to_date('2012-03-20','yyyy-mm-dd') from emp
select to_char(sysdate,'yyyy-mm-dd') from emp
2.to_date函数将字符装成日期
select to_date('2012-03-20','yyyy-mm-dd') from emp