I am trying to run some INSERT INTO SQL command in OpenOffice Base and i get the

Question

I am trying to run some INSERT INTO SQL command in OpenOffice Base and i get the error message below

1: Wrong data type: java.lang.IllegalArgumentException)

The Create table code is as below:

create table Books

(

BookId integer PRIMARY KEY,

SequenceNumber integer,

Title char(50),

ISBN char(14),

Author char(30),

cost decimal(7,2),

publication_date date

);

And the INSERT INTO commands are:

insert into Books values(1,1,'Alice in Wonderland','1441435840','Lewis Corell',7.95,'5/1/1997');

insert into Books values(2,1,'A First Course in Database Systems','978-0136006374','Jeffrey Ullman',99.49,'10/6/2007');

insert into Books values(3,1,'Database Systems Concepts','978-0073523323','Abrahm Silberchatz',119.67,'01/27/2010');

Any advice?

Explanation / Answer

try to change format as '1997-05-01'

insert into Books values(1,1,'Alice in Wonderland','1441435840','Lewis Corell',7.95,'05-01-1997');

insert into Books values(2,1,'A First Course in Database Systems','978-0136006374','Jeffrey Ullman',99.49,'10-06-2007');

insert into Books values(3,1,'Database Systems Concepts','978-0073523323','Abrahm Silberchatz',119.67,'01-27-2010');

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.