当前位置:数据库 > 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);

 


Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,