各位高手帮我看看错在哪里

[小婷_wuni]

$id="1";
$user_name="cht";
$time="2001-10-15";
$method="sff";
$starve=0;
$sptotal=100;
$reman="cht";
$memo="ghj";
$conn=ocilogon("cht","cht","sm");
$query="insert into orders(orderid,username,orderdate,delivertime,paymentmethod,starve,totalprice,reciveman,tag,memo)";
$query.="values(:orderid,:username,SYSDATE,to_date(:delivertime),:paymentmethod,:starve,:totalprice,:reciveman,0,:memo)";
$stmt=ociparse($conn,$query);
ocibindbyname($stmt,":ORDERID",&$id,-1);
ocibindbyname($stmt,":USERNAME",&$user_name,-1);
ocibindbyname($stmt,":DELIVERTIME",&$time,-1);
ocibindbyname($stmt,":PAYMENTMETHOD",&$method,-1);
ocibindbyname($stmt,":STARVE",&$starve,-1);
ocibindbyname($stmt,":TOTALPRICE",&$sptotal,-1);
ocibindbyname($stmt,":RECIVEMAN",&$reman,-1);
ocibindbyname($stmt,":MEMO",&$memo,-1);
ociexecute($stmt);
ocifreestatement($stmt);
ocilogoff($conn);
错误信息：Warning: OCIStmtExecute: ORA-01861: literal does not match format string in D:\page\dzsw\t.php on line 52

[sdliubo]

是类型不匹配了,看看是不是数字型的插入了字符型的

[duduxiao]

ww