date problem

Hi! i am using oracle sql and ASP to do my shopping cart.
Below is a snippet of my asp codes.

sqlString = "INSERT INTO orders ( " &_
"order_userID, " &_
"order_ccnumber, " &_
"order_entrydate " &_
") VALUES ( " &_
" '" & userID & "'," &_
" '" & ccnumber & "', " &_
" '" & NOW() & "' " &_
")"


If I use response.write, i will see

INSERT INTO orders ( order_userID, order_ccnumber, order_entrydate ) VALUES ( '41', '1111222233334444', '3/25/2004 1:57:10 PM' )

which is correct. But if i use Conn.Execute, it will prompt me an error that says invalid month. This is my table in oracle sqlplus. Pls tell me what's wrong and how to rectify it. Thanks

create table orders(
order_id INTEGER not null,
order_userID INTEGER not null,
order_entrydate date,
order_ccnumber INTEGER);

Hi,

Try running

INSERT INTO orders ( order_userID, order_ccnumber, order_entrydate ) VALUES ( '41', '1111222233334444', to_date('3/25/2004 1:57:10' ,'mm/dd/yyyy hh24:mi:ss') ;