insert into test_main(riqi) values(to_date('2012-03-01 15:12:24','yyyy-mm-dd hh24:mi:ss')); 查询时,select to_char(riqi,'yyyy-mm-dd hh24:mi:ss') from test_main;