how to insert a date in sqlite from java?

Question

I'm trying to insert a date in SQLite database, can anyone help me with the query this is my query:

ResultSet rs = stmt.executeQuery( "INSERT INTO date VALUES (10/10/2020)");

an this is the error that i'm having :

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "30": syntax error)

java.sql.SQLException: query does not return ResultSet thats what i had when i used ResultSet rsNote = stmtNote.executeQuery( "INSERT INTO date VALUES (2020-10-10)"); — mohamed, May 25 '17 at 17:45
You shouldn't use `executeQuery` for insert operation. Use `executeUpdate` or `execute`. http://javaconceptoftheday.com/difference-between-executequery-executeupdate-execute-in-jdbc/ — Shaishav Jogani, May 25 '17 at 17:49
stmtNote.executeUpdate( "INSERT INTO date VALUES (2020-10-10)"); and it added 2000 to the database — mohamed, May 25 '17 at 18:01
Don't get me wrong...but are you really doing any research before asking? You post the error and wait for answer!!! — Shaishav Jogani, May 25 '17 at 18:06
@ShaishavJogani No, for date-time values use date-time objects, not strings. — Basil Bourque, May 26 '17 at 05:15

score 0 · Answer 1 · answered May 25 '17 at 20:18

0

"INSERT INTO date VALUES (2020-10-10)" will insert 2000, as you reported, because 2020-10-10 = 2010-10 = 2000 (this is an integer evaluation). If you want a string, then specify it - "INSERT INTO date VALUES ('2020-10-10')"

answered May 25 '17 at 20:18

varro

2,382
2
16
24

how to insert a date in sqlite from java?

1 Answers1