CODEWITHSUNDEEP
sqlite
Isaac
Isaac

Reputation: 351

Identifying what date this value represents in SQLite

I am brand new (!) to SQLite and will not be studying or using it long-term; however, I am trying to paw through a bit of archived data in a sqlite database using db browser for sqlite.

There is a table with a date field with a value like this: 1435610912000000

Does that make any sense to anyone as to a date of some kind ??

Upvotes: 0

Views: 27

Answers (2)

Jideobi Benedine Ofomah
Jideobi Benedine Ofomah

Reputation: 496

This can be a timestamp which every programming language has a function for converting it to a Date objec. 

var date = new Date(1435610912000000);

This code above is Javascript that casts the number 1435610912000000 to date 

Sat Sep 13 47462 01:53:20 GMT+0100 (WAT)

which is a bit off but the best guess is that it is a timestamp

Upvotes: 0

vontell
vontell

Reputation: 342

That is the number of microseconds from 1970 (epoch). Therefore, that is 1435610912000 milliseconds (or 1435610912 seconds), which converts to Mon Jun 29 2015 20:48:32 UTC using this website.

Upvotes: 1

Related Questions