CONVERT date in this format, 1498990899643994356, with 19 characters

Autopsy Help
#1

Good afternoon,

I have this date in this format, 1498990899643994356, with 19 characters,
I’m making this code datetime(last seen / 1000000000, ‘unixepoch’) as last seen , as shown in the figure,
and the autopsy result always appears "1970-01-01 01:33:37 GMT.

image
image1840×797 76.3 KB

result always appears

image

#2

Hi Ricardo.

In your select, what happens if you update your SQL query to wrap it around strftime() like this:

SELECT msid, strftime('%s', datetime(lastscene/1000000000, 'unixepoch')) lastscene, mssname, ...