As a handle is created from the date when an object is created, is it possible to reverse the operation in order to know this creation date? I’ve tried this with Supertool but it don’t work: init: from datetime import date as dt statement: hand = float.fromhex(obj.handle[0:10]) print(hand, dt.f…

Thanks Paul ! Yes, it still requires a little calculation: dividing handle[0:11] by 10000. This SuperTool script allow you to retrieve any object creation date (don’t care about people category warning): [Gramps SuperTool script file] version=1 [title] SuperTool - Object Creation Date [category…

Thanks George, I think I use (I’ve translated) the formula DATE ( ( 0xd897668328b / 864000000.0 ) + 2440587.5 ) as exposed in my first post but it doesn’t give me satisfaction. With 11 hex it give me this and I’m sure I don’t created anything in 1972 6.656658947078206e+16 1972-07-09 79485251.23933…

I’m not sure that formula is correct. From our code the handle is: “%08x%08x” % (int(time.time()*10000), _rand.randint(0, sys.maxsize)) So the observation that its the first 11 hex digits that of interest is probably correct. And from the Python docs the time.time() is: time. time () → float R…

Just to clarify, the formula in my post is what worked for me in sqlite3, for example: sqlite> select DATE ( ( 0xd897668328b / 864000000.0 ) + 2440587.5 ); 2017-03-01

Added some “See also” cross-references to this information on the Wiki section on Using the Database API:Handles . Seems inadequate to me (since there would be too much bouncing from link to link) What should be added to make the Wikipage a useful reference page?

Reversing an object handle to its creation date

Help

GeorgeWilmes July 19, 2022, 1:20pm 2

Yes, see here.

Topic		Replies	Views
"handle" and "change" columns in sqlite export Help	1	650	January 3, 2021
Time of creation Help	8	577	May 20, 2023
Making date input more flexible Ideas hacks , dates , supertool-script	20	1603	January 27, 2026
Dateval field of Date object content Help third-party-addon , supertool-script	6	579	January 18, 2022
What are the limits for the Date sort value? Help	6	178	September 21, 2024

Reversing an object handle to its creation date

Related topics