Date类型错误
insert into sjtbjkpre(fgs,gpolicyno,classcode,paydate,pcode,pname,amount) values('A030100','080G101EP400003','EP4021','04/06/2010','1','??????????·?','150000')
我这样写 报错:
String to date conversion error
改成这样:
insert into sjtbjkpre(
fgs,gpolicyno,classcode,paydate,pcode,pname,amount)
values('A030100','080G101EP400003','EP4021',
to_date('04/06/2010','%m/%d/%Y'),'1','??????????·?','150000')
结果报错:
201: A syntax error has occurred.
insert语句 怎么插入一个 Date啊??????????
为什么 to_date在select中就正常了!???
select to_char(regdate,'%m/%d/%Y') a1,
to_date('04/08/2010','%m/%d/%Y') a2,
TODAY,extend(regdate,year to day) from sjtbjkpay