Register and join over 40,000 other developers!
Recent Topics
-
Print specific values from dictionary with a specific key name
Siten0308 - Jun 20 2019 01:43 PM
-
Learn algorithms and programming concepts
johnnylo - Apr 23 2019 07:49 AM
-
Job Gig PHP Form Needed
PJohnson - Apr 18 2019 03:55 AM
-
How to make code run differently depending on the platform it is running on?
xarzu - Apr 05 2019 09:17 AM
-
How do I set a breakpoint in an attached process in visual studio
xarzu - Apr 04 2019 11:47 AM
Recent Blog Entries
Recent Status Updates
Popular Tags
- networking
- Managed C++
- stream
- console
- database
- authentication
- Visual Basic 4 / 5 / 6
- session
- Connection
- asp.net
- import
- syntax
- hardware
- html5
- array
- mysql
- java
- php
- c++
- string
- C#
- html
- loop
- timer
- jquery
- ajax
- javascript
- programming
- android
- css
- assembly
- c
- form
- vb.net
- xml
- linked list
- login
- encryption
- pseudocode
- calculator
- sql
- python
- setup
- help
- game
- combobox
- binary
- hello world
- grid
- innerHTML

4 replies to this topic
#1
Posted 10 April 2011 - 12:49 AM
Hi all-
Sorry if this is the wrong place to post this, just I have been looking all over for an answer and can't seem to find one, so a programming forum seemed to be somewhere I might find an answer.
I am using SQLite Database Browser to read the history logs from my browser, but I would like to be able to see the date and time of a visit. These are in the "last_visit_time" column stored as a string of numbers. I am not sure how to read them? Is there any way to convert this string of numbers to a readable date? I found a site (Epoch Converter - Unix Timestamp Converter) that gives me a date when I paste in the numbers, but I know they are wrong because I looked at a query I knew was searched for at a later date and it shows the date as being much earlier. For example, it says "12946608999984000" is mon, jan 10, 2011, when I know that it is actually from march or april.
Is there any way I can read these dates properly? Maybe I am searching using the wrong terms, but I can't find anything, so any help would be greatly appreciated. Thank you!
Sorry if this is the wrong place to post this, just I have been looking all over for an answer and can't seem to find one, so a programming forum seemed to be somewhere I might find an answer.
I am using SQLite Database Browser to read the history logs from my browser, but I would like to be able to see the date and time of a visit. These are in the "last_visit_time" column stored as a string of numbers. I am not sure how to read them? Is there any way to convert this string of numbers to a readable date? I found a site (Epoch Converter - Unix Timestamp Converter) that gives me a date when I paste in the numbers, but I know they are wrong because I looked at a query I knew was searched for at a later date and it shows the date as being much earlier. For example, it says "12946608999984000" is mon, jan 10, 2011, when I know that it is actually from march or april.
Is there any way I can read these dates properly? Maybe I am searching using the wrong terms, but I can't find anything, so any help would be greatly appreciated. Thank you!
#2
Posted 10 April 2011 - 05:38 AM
What I would do is write a few records, with known and different dates. Then read those values out and use Epoch Converter to see what values you get back. You should be able to reverse engineer it with only 2-4 records.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog
My MineCraft server site: http://banishedwings.enjin.com/
#3
Posted 10 April 2011 - 09:03 AM
What I would do is write a few records, with known and different dates. Then read those values out and use Epoch Converter to see what values you get back. You should be able to reverse engineer it with only 2-4 records.
How would I reverse engineer the numbers? Sorry for the dumb question, I just have no idea how to do any of this. I went to a site so that I could look at the history and know a definite date and time, so I know that "12946927443604125" is today, Sunday, 4/10/2011, at 11:44 AM Central time. Do you think you could give me an example of how to work with this?
Also, the site says "assuming the timestamp is in milliseconds" when I enter the numbers, but I thought I read maybe it used microseconds? So I tried using a converter to convert the microseconds to milliseconds and then plugging it in there, but it gives me more numbers than the converter will allow so it doesn't work either. Any help would be greatly appreciated, thanks so much.
#4
Posted 10 April 2011 - 09:49 AM
Also, this is my history file from google chrome. I tried looking at my history from firefox, and when I use that string of numbers, it actually works. For example, "1300014497764000" gives me march 13, which I know is right. When I paste those numbers into the box to convert them, it only allows 13 numbers, so it cuts off the last three zeros = "1300014497764". Compared to this, the chrome dates have one extra number plus the three zeros, so..."12945325696683000," even if I try pasting the numbers into the converter minus the three zeros, there is still an extra number that won't fit, and it's the wrong date. Not sure if this helps at all...
#5
Posted 10 April 2011 - 12:23 PM
SQLite Query Language: Date And Time Functions
Unix time - Wikipedia, the free encyclopedia
At a guess, the extra three 0's are for thousandths of a second.
Unix time - Wikipedia, the free encyclopedia
At a guess, the extra three 0's are for thousandths of a second.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog
My MineCraft server site: http://banishedwings.enjin.com/
Also tagged with one or more of these keywords: SQLite, sqlite
General Forums →
Mobile Development →
Display array column using spinnerStarted by DarkHeart, 04 Apr 2015 ![]() |
|
![]() |
||
General Forums →
Mobile Development →
Query 2 spinnersStarted by DarkHeart, 31 Mar 2015 ![]() |
|
![]() |
||
General Forums →
Mobile Development →
App crashes when trying to display Listview from DatabaseStarted by DarkHeart, 29 Mar 2015 ![]() |
|
![]() |
||
General Forums →
Mobile Development →
Cant display database table in a listviewStarted by DarkHeart, 29 Mar 2015 ![]() |
|
![]() |
||
![]() Save checkboxes to SQLite DatabaseStarted by DarkHeart, 26 Mar 2015 ![]() |
|
![]() |
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download