Hi all, I have the following MySQL statement and I wish to insert the same data into a Derby table.
INSERT INTO analysis VALUES (6,'0000-00-00 00:00:00','RNASeqGene',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL) My Derby table is of the fomat (some columns missing). ======== COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ ANALYSIS_ID |SMALLINT |0 |10 |5 |NULL |NULL |NO CREATED |TIMESTAMP|9 |10 |29 |NULL |NULL |NO LOGIC_NAME |VARCHAR |NULL|NULL|128 |NULL |256 |NO DB |VARCHAR |NULL|NULL|120 |NULL |240 |YES DB_VERSION |VARCHAR |NULL|NULL|40 |NULL |80 |YES DB_FILE |VARCHAR |NULL|NULL|120 |NULL |240 |YES PROGRAM |VARCHAR |NULL|NULL|80 |NULL |160 |YES ================ >From here http://db.apache.org/derby/docs/10.5/ref/rrefsqlj27620.html, is *_appears_* that my data is OK, but I get the error ============== Error: The string representation of a date/time value is out of range. SQLState: 22007 ErrorCode: 30000 =============== >From Squirrel SQL. Could anybody kindly point out where I'm going wrong? TIA and rgs, Paul... -- [email protected] Mob: 00 353 86 864 5772
