I’m using libreoffice base for a little project. I’m new to it, I usually use myQSL or SQLite for my projects. I can’t insert values in the table where I have a DATE column.
CREATE TABLE SELL
(
date_ DATE NOT NULL PRIMARY KEY,
quantity_ NUMERIC(5) NOT NULL,
CONSTRAINT c1 CHECK(YEAR(date_)>2004),
CONSTRAINT c2 CHECK(YEAR(date_)<YEAR(CURRENT_DATE))
);
INSERT INTO SELL VALUES('11/11/02', 3);
And the result is: Wrong data type: java.lang.IllegalArgumentException: 11/11/02
I’m using the Italian settings as Locale that’s why I’m using DD/MM/YY
EDIT: the query is actually
INSERT INTO SELL VALUES(‘11/11/05’, 3);