insert into Table_name(date) values(to_date('20050825','yyyymmdd'));
alter session set nls_date_format='DD-MM-YYYY';insert into test(dt) values ('25-8-2005');
针对当前session有效: alter session set nls_date_format='DD-MM-YYYY';insert into test(dt) values ('25-8-2005');针对所有session有效: insert into Table_name(date) values(to_char(sysdate,'yyyy-mm-dd'));
alter session set nls_date_format='DD-MM-YYYY';insert into test(dt) values ('25-8-2005');针对所有session有效:
insert into Table_name(date) values(to_char(sysdate,'yyyy-mm-dd'));
2 to_date('','')