SQL> create table test( 2 c1 date );Table created.SQL> insert into test values (to_date('2003-02-20','yyyy-mm-dd'));1 row created.SQL> insert into test values (to_date('2003/02/20','yyyy/mm/dd'));1 row created.SQL> select * from test;C1 --------- 20-FEB-03 20-FEB-03
2 c1 date );Table created.SQL> insert into test values (to_date('2003-02-20','yyyy-mm-dd'));1 row created.SQL> insert into test values (to_date('2003/02/20','yyyy/mm/dd'));1 row created.SQL> select * from test;C1
---------
20-FEB-03
20-FEB-03
如果你需要取出数据进行操作比较的时候可以用to_char()转字符串函数