store long value in android database

android android-sqlite
zafi005 picture zafi005 · Sep 25, 2012 · Viewed 20.8k times · Source

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 .

Answer

keyser picture keyser · Sep 25, 2012

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.

Datatypes In SQLite Version 3

Related questions

How to access data/data folder in Android device?

I am developing an app and I know my database *.db will appear in data/data/com.****.*** I can access this file from AVD in Eclipse with help of sqlite manager But I can't access this file in my Android …

Read More
View contents of database file in Android Studio

I have been using Android Studio to develop my app since it's was released. Everything works nice until recently, I have to debug together with checking the database file. Since I don't know how to see the database directly, When …

Read More
Ship an application with a database

If your application requires a database and it comes with built in data, what is the best way to ship that application? Should I: Precreate the SQLite database and include it in the .apk? Include the SQL commands with the …

Read More