insert empty timestamp into db2 using jsp
Posted on 2005-03-17
I am using DB2. I want to insert a record using JSP.
The table is as follow :
COLUMN NAME: A (primary key) , B ,C
DATA TYPE: TIMESTAMP, DATE
I am using JSP to insert a record.
my sql statement is as follow :
INSERT INTO TBL_AAA VALUES ('P1','','')
however I get the follow error:
com.ibm.db2.jcc.c.SqlException: The syntax of the string representation of a datetime value is incorrect.
THE DATA SAMPLE IS AS FOLLOW:
P2, FEB 3,2005 2:40:03 PM 218000 , DEC 14, 2004
Would somebody please help me ?