当增改查的时候,to_char和to_date的用法
select to_char(sysdate,'yyyy-mm-dd') from dual
update teachers set hire_date=to_date('2012-06-01','yyyy-mm-dd') where teacher_id=12
insert into teachers (teacher_id,name,hire_date)values(13,'13',to_date('2012-06-06','yyyy-mm-dd'))