Chrome history- datetime format

[iivaf...@gmail.com]

Good day all.

I decided to write the programm to analize history my websurfing. But i have one problem- chrome use 17 digital datetime format(13016899277273330 - ?), usual unix format is 10 digital(1374079548 - 17.07.2013 16:45:48). And i have one question- how translate it correctly to usual time (17.07.2013 16:45:48 fro ex.)

[PhistucK]

Where do you see this 17 digit format?

(I guess it is in CPU ticks)

☆PhistucK

On Tue, Jul 23, 2013 at 9:16 PM, <iivaf...@gmail.com> wrote:

Good day all.

I decided to write the programm to analize history my websurfing. But i have one problem- chrome use 17 digital datetime format(13016899277273330 - ?), usual unix format is 10 digital(1374079548 - 17.07.2013 16:45:48). And i have one question- how translate it correctly to usual time (17.07.2013 16:45:48 fro ex.)

--
--
Chromium Discussion mailing list: chromium...@chromium.org
View archives, change email options, or unsubscribe:
http://groups.google.com/a/chromium.org/group/chromium-discuss
 
 
 

[iivaf...@gmail.com]

Chrome  put his history to sqlite database- for example file  History table- url field- last_time_visits -- 13010924032000000  type- integer

[PhistucK]

Looks like you stated the wrong field name, it is last_visit_time and not last_time_visits. That could have saved me a minute.

Looks it is microseconds in UTC -

https://code.google.com/p/chromium/codesearch#chromium/src/base/time/time.h&sq=package:chromium&l=486&dr=C&rcl=1374551416

Discovered via -

https://code.google.com/p/chromium/codesearch#chromium/src/base/time/time.h&sq=package:chromium&l=381&dr=C&rcl=1374551416

Via -

https://code.google.com/p/chromium/codesearch#chromium/src/chrome/browser/history/history_unittest.cc&sq=package:chromium&q=last_visit_time%20history&ct=rc&cd=5&l=1694&dr=C

Via -

https://code.google.com/p/chromium/codesearch#search/&sq=package:chromium&q=last_visit_time%20history&type=cs

☆PhistucK

[iivaf...@gmail.com]

Sorry- this is my mistake about field name.

I think about microseconds-- look-- time value 13010924032000000 div 1 000 000 equal   13010924032-- 11 digital and this is not true utc format. and if i miss last digital - i have wrong time(2011 year)- i install Chrome in 2012 year

[PhistucK]

Yes, there is some calculation I have not been able to figure out quickly.

https://code.google.com/p/chromium/codesearch#chromium/src/base/time/time_posix.cc&sq=package:chromium&type=cs&l=100&rcl=1374551416

Maybe others can chime in.

☆PhistucK

[iivaf...@gmail.com]

Thanks you a lot.

I find reason. usual utc Unix-like system (Jan 1, 1970) Chrome start from  new date 1601 so difference 11644473600 second to calculate usual date.

Thanks you to helpfull links

[PhistucK]

I found that, too, but when calculating, it still did not provide me with a logical date - but perhaps I gave up too quickly and made some mistake along the way. What does 13016899277273330 calculate to?

☆PhistucK

[iivaf...@gmail.com]

13016899277273330 div 1000 000 = 13016899277 - 11644473600(delta!!!)= 1372425677  ==Fri, 28 Jun 2013

[PhistucK]

Cool.

☆PhistucK