在oracle插入日期

2014-11-24 16:18:17 · 作者: · 浏览: 0
在oracle插入日期
TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss')

insert into CT_FILESAVE_POLICY 
values(95,1,'aaa','aaa','aaa','ddd','aaa',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,
'ddd',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,1);
insert into CT_FILESAVE_POLICY 
values(91,1,'aaa','aaa','aaa','ddd','aaa',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,
'ddd',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,1);
insert into CT_FILESAVE_POLICY 
values(92,1,'aaa','aaa','aaa','ddd','aaa',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,
'ddd',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,1);
insert into CT_FILESAVE_POLICY 
values(93,1,'aaa','aaa','aaa','ddd','aaa',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,
'ddd',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,1);
insert into CT_FILESAVE_POLICY 
values(94,1,'aaa','aaa','aaa','ddd','aaa',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,
'ddd',TO_DATE('20070523 21:23:34','yyyy-mm-dd hh24:mi:ss') ,1);