Adam10541 0 Posted June 4, 2014 Share Posted June 4, 2014 I'm using various SQL database viewers to have a look at an .exb file and the date format is causing me some confusion. I'm seeing 734508.1448 As the created date. Can anyone shed some light on the format used? Is this a case of SQL tools not quite understanding what they are looking at and just trying to interpret it? Link to comment
SebR 146 Posted June 4, 2014 Share Posted June 4, 2014 Format seems to be UNIX timestamp and the date here is Fri, 09 Jan 1970 12:01:48 GMT http://www.onlineconversion.com/unix_time.htm Link to comment
Adam10541 0 Posted June 4, 2014 Author Share Posted June 4, 2014 I probably should have given a few more details but I was running out the door from work when I posted. SebR, I'm not sure if that was a tongue in cheek post or not, but I'm fairly sure that Windows 7 didn't exist in 1970 In any case it was created at some point in the last 12 months and that's as accurate as I can be at this point. I had considered Unix time but the format doesn't fit. Link to comment
Level 5* jefito 5,598 Posted June 4, 2014 Level 5* Share Posted June 4, 2014 It's star date, I believe... ...actually, as far as I know, the date's no publicly documented; it doesn't seem to match up with the documented date formats in the Evernote format. Link to comment
SebR 146 Posted June 4, 2014 Share Posted June 4, 2014 Adam, seems logical there must be an offset to add to it like the db's creation date ;-) Link to comment
Adam10541 0 Posted June 4, 2014 Author Share Posted June 4, 2014 Seb as a dedicated trekkie I'm both sad and ashamed to admit I actually googled 'star date' I'm clearly too tired to be trying to tackle this issue right now.. I will check the db creation time when I return to work tomorrow. It's also been suggested to me by a SQL guru that the 734508 is an integer counting the number of days since 1/1/0000 and the 1448 is a fractional representing the time. This seems to fit as 734508 days is 2011.2 years, and I'm told 1448 converts to 1448 = 86400 *.1448 = 3:28:30, however I'm lost when it comes to this type of math so I'm sort of waiting for that learned person to have the time to explain further. Further searching has led me to believe 734508.1448 is a serial date/time format, it's just trying to convert it that is causing me some grief. Link to comment
Level 5* jefito 5,598 Posted June 4, 2014 Level 5* Share Posted June 4, 2014 This documentation might help: Datatypes In SQLite Version 3 Link to comment
Adam10541 0 Posted June 5, 2014 Author Share Posted June 5, 2014 I should point out that excel was truncating the full number, the full date/time is actually734508.144780093 Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.