store long value in android database

Question

How do I store long values in Android SQLite database ? I am trying to store the time(milliseconds) values which comes in long type format .

keyser · Answer 1 · 2014-10-27T19:09:37.260

55

An INTEGER column will handle long values.

From the SQLite site:

INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.

edited Oct 27 '14 at 19:09

answered Sep 25 '12 at 14:01

keyser

score 3 · Answer 2 · answered Sep 25 '12 at 14:04

3

You can define a column with Integer datatype. For more info go through this link

answered Sep 25 '12 at 14:04

Aswin

score 1 · Answer 3 · answered Sep 25 '12 at 14:03

1

If you don't care about sign, store it as INT8. It's 8 bytes (64 bits) unsigned. Or, convert to/from string.

answered Sep 25 '12 at 14:03

Simon

INT8 will be converted to INTEGER in sqlite. (Or, at least that's how I understood the affinity section) – keyser Sep 25 '12 at 14:05

3 Answers3