Storing unix timestamp in sql

Question

I have a unix date in long format

Long tmpLong = (Long) local.getValue();

Here is the value of tmpLong

1485710457166

Now I want to store this variable inside of my SQLite DB, after some research I found out that you cant store Longs in SQLite so I tried this:

Long tmpLong = (Long) local.getValue();
Integer tmpInt = tmpLong.intValue();

But this gives me:

-348227250

In SQLite my datatype is INTEGER

I need help storing this unix number, any help is appreciated

Update 1

If I try store it as a long, so

localDB.add(image_id, unixTimestamp, PATH);

And then in my add method (inside SQLiteHelper class). I print the value for testing :

 public void add(String image_id, Long date, String path) {
    SQLiteDatabase db = this.getWritableDatabase();
    Log.d("SQL", "date " + date);

It prints 1

D/SQL: date 1

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Well, that is what will happen when you truncate a 64 bit Long into a 32 bits integer...

Dont do that but try to store it like it is (as a long) because SQLite ints can handle that values, take a look into the Datatypes In SQLite

Edit:

Your code below:

public void add(String image_id, Long date, String path) {
    SQLiteDatabase db = this.getWritableDatabase();
    Log.d("SQL", "date " + date);
}

if that code is so as it is posted then you are passing as parameter 1 for the date value... the method this.getWritableDatabase(); is not going to modify/change the value of the date parameter...

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 29, 2017 at 20:05

ΦXocę 웃 Пepeúpa ツ

48.4k17 gold badges77 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

memoryManagers Over a year ago

well, before the data is sent to that class I check the unix value and its correct, when it gets to the next class its 1 which i know doesnt make any sense

memoryManagers Over a year ago

nevermind I found the problem =, it was not to do with the date

Collectives™ on Stack Overflow

Storing unix timestamp in sql

1 Answer 1

Edit:

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Edit:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related