how to define long in SQLite

Question

I need to create table column which contains data of type long, what am trying is to create column like this

+other columns

KEY_DATE_CREATED + " LONG OR something else**(DONT KNOW HOW TO DEFINE IT)**"

+other columns

what i'm trying to pass to that column is this below, which is from type long.

long dateM = Calendar.getInstance().getTimeInMillis();

tnx a lot!

http://www.sqlite.org/datatype3.html. there is no Long type. You can use Integer — Raghunandan, Jan 15 '14 at 20:18

score 2 · Answer 1 · edited Jan 15 '14 at 20:28

2

An INTEGER column will handle long values.

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 Jan 15 '14 at 20:28

CL.

answered Jan 15 '14 at 20:19

brandonjsmith

1

nice copy/paste http://stackoverflow.com/questions/12584539/store-long-value-in-android-database – Android Jan 16 '14 at 00:01
yup, it was just as quick as adding a link – brandonjsmith Jan 16 '14 at 20:09

1 Answers1