Hi,
I am new to
Sqlite and am trying to work with the Firefox database
formhistory.sqlite.
The
firstused field is of type INTEGER and I assume a representation of a date.
My problem is that the date integer is 143581835467200. I've tried
Code:
SELECT datetime(143581835467200, 'unixepoch', 'localtime');
which gives me garbage. NOTE: The example Sqlite gives of this function uses a 10 digit integer not 16 digit.
I can't determine what function will convert this INTEGER to a meaningful date,time string.
R