当前位置:数据库 > Oracle >>

在oracle插入日期

在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);

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,