请问:在java中定义时间用什么定义才能往oracle数据库里插入date类型的数据啊
我这里报错是java.sql.SQLException: ORA-01861: literal does not match format string
我java中用 Timestamp oracle中用Date
SQL语句如下
insert into mail_req(mr_id,mr_mail,mr_startarea,mr_endarea,mr_starttime, mr_reqstat,mr_endreqtime)
values (mail_req_seq.nextval,'[email protected]',123,321,'2008-09-25 09:48:28.509',0,'2008-03-25 09:48:28.509')
我这里报错是java.sql.SQLException: ORA-01861: literal does not match format string
我java中用 Timestamp oracle中用Date
SQL语句如下
insert into mail_req(mr_id,mr_mail,mr_startarea,mr_endarea,mr_starttime, mr_reqstat,mr_endreqtime)
values (mail_req_seq.nextval,'[email protected]',123,321,'2008-09-25 09:48:28.509',0,'2008-03-25 09:48:28.509')
如果你的时间是 '2008-09-25 09:48:28'
把这些替换成to_date('2008-09-25 09:48:28','yyyy-mm-dd hh24:mi:ss')