Android sqlite store date types

Question

I need to store dates in my app database and i need to know if is possible to create a table with a date type column in Android Sqlite like this:

"CREATE TABLE example1 (ex_id INTEGER PRIMARY KEY, ex_date DATE)"

http://www.sqlite.org/lang_datefunc.html – Kirit Vaghela Dec 10 '13 at 13:32 — Kirit Vaghela, Dec 10 '13 at 13:32

score 4 · Accepted Answer · answered Dec 10 '13 at 12:53

4

No it is not.

But you can use Date.getTime(), to have the timestamp (long in JAVA, INTEGER in SQLite), to be able to store and retrieve the date.

To retrieve the date from database, you will do :

new Date(cursor.getLong(yourColumnIndex));

And to store it :

contentValues.put("yourDateColumn", date.getTime());

answered Dec 10 '13 at 12:53

... or format date as string, or get floating point Julian day, or ... – LS_ᴅᴇᴠ Dec 10 '13 at 13:34
yep, but integer is the fastest and lower way to store dates. – Dec 10 '13 at 13:41
And who told you "fastest" was a requirement? Any of those methods have their own advantages and drawbacks. – LS_ᴅᴇᴠ Dec 10 '13 at 13:42

Pratik Butani · Answer 2 · 2013-12-10T13:34:17.130

0

Try Like this:

/* Creating Table */
String query = "CREATE TABLE " + TABLE_ORDER_DETAILS
+ "("
+ OD_LOCAL_TIME + " TEXT,"
+ OD_SERVER_TIME + " TEXT "
+ ")";

db.execSQL(query);

edited Dec 10 '13 at 13:34

answered Dec 10 '13 at 13:28

Pratik Butani

60,504
58
273
437

-1 `TIMESTAMP` is not any recognized type to SQLite! `TIMESTAMP` will get `NUMERIC` affinity [SQLite3 data types](http://www.sqlite.org/datatype3.html)! – LS_ᴅᴇᴠ Dec 10 '13 at 13:32
Your answer doesn't answer question. You created `TEXT` columns. OP wants date data type. And now what? – LS_ᴅᴇᴠ Dec 10 '13 at 13:47
`Text` is not desirable in this context. – aslamhossin Mar 17 '17 at 06:22

Android sqlite store date types

2 Answers2