Obk/cookies: Conversion Of Timestamp "creation_utc"

frml@free.fr
frml@free.fr
edited June 2014 in Safepay

Hi all,


I am searching answers for the following question : howto convert the timestamp value of the field/column "creation_utc" used by OBK to store Internet Cookies sessions' website analyses. The field is part of the SqlLite file database "C:\ProgramData\Bitdefender\Desktop\OBK\{User_Profile_Name}\.cache\Cookies"


The timestamp stored in field/colum "creation_utc" is made of 17 numeric caracters which does not correspond to usual/correct date & time using appropriate timestamp conversion tools/methods !


Here is an example of value and observed timestamp conversions :


Value of creation_utc = 13043370128846700


estimation of real date = May, 7th 2014 (5/7/2014)


timestamp conversion of all 17 caracters => 9/23/2005


timestamp conversion of first 15 caracters => 11/30/1964


timestamp conversion of first 14 caracters => 11/19/1955


Both computer OS & bios time are set correctly and equal. Local time set of the computer is GMT+1 (eg. UTC + 1 hour)


Best regards

Comments

  • camarie
    camarie Principal Software Developer BD Staff
    Hi all,


    I am searching answers for the following question : howto convert the timestamp value of the field/column "creation_utc" used by OBK to store Internet Cookies sessions' website analyses. The field is part of the SqlLite file database "C:\ProgramData\Bitdefender\Desktop\OBK\{User_Profile_Name}\.cache\Cookies"


    The timestamp stored in field/colum "creation_utc" is made of 17 numeric caracters which does not correspond to usual/correct date & time using appropriate timestamp conversion tools/methods !


    Here is an example of value and observed timestamp conversions :


    Value of creation_utc = 13043370128846700


    estimation of real date = May, 7th 2014 (5/7/2014)


    timestamp conversion of all 17 caracters => 9/23/2005


    timestamp conversion of first 15 caracters => 11/30/1964


    timestamp conversion of first 14 caracters => 11/19/1955


    Both computer OS & bios time are set correctly and equal. Local time set of the computer is GMT+1 (eg. UTC + 1 hour)


    Best regards


    This is not a support question; it is an internal value.


    Why do you need it?


    Cristian

All Time Leaders

Categories

Defenders of the month