Skip to Content
0
May 02, 2007 at 03:23 PM

Timestamp Field

20 Views

Hi Friends;

I have oracle database and one of myfield is timestamp.

I want to execute insert statement in jsp. but it always gives me

2007-05-02 17:51:36.321 The SQL statement 
"INSERT INTO "TBL_MSG" ("ID","SENDER","RECIPIENT","SUBJECT",
"BODY","ATTACHMENTS","SENTDATE","IP","STATUS","VIEWTIMES") 
VALUES ('125345345','TESTFIT','TESTFIT','sdfgsadgasdg',' qertertsd',
'asd','02-May-07 05:11:55','10.1.21.88','0',0)" 
contains the semantics error[s]: - type check error: 
new value (element number 7 (CHAR)) is not assignable 
to column >>SENTDATE<< (TIMESTAMP) 

How can i insert this timestamp field in jsp?

Thanks

Best Regards