# CONVERT date in this format, 1498990899643994356, with 19 characters

**URL:** <https://sleuthkit.discourse.group/t/convert-date-in-this-format-1498990899643994356-with-19-characters/2960>\
**Category:** Autopsy Help\
**Created:** [November 22, 2021, 1:49am UTC](https://sleuthkit.discourse.group/t/convert-date-in-this-format-1498990899643994356-with-19-characters/2960 "2021-11-22T01:49:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ricardo\_Marques](https://yyz2.discourse-cdn.com/free1/user_avatar/sleuthkit.discourse.group/ricardo_marques/32/1304_2.png) [@Ricardo\_Marques](https://sleuthkit.discourse.group/u/Ricardo_Marques)\
**Post date:** [November 22, 2021, 1:49am UTC](https://sleuthkit.discourse.group/t/convert-date-in-this-format-1498990899643994356-with-19-characters/2960/1 "2021-11-22T01:49:46Z")

</div>

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](https://global.discourse-cdn.com/free1/uploads/sleuthkit/original/2X/e/ec22ce3ad498ddfa923e40eee907b851c18d9e6a.png)

result always appears

![image](https://global.discourse-cdn.com/free1/uploads/sleuthkit/original/2X/d/db83d88a972208540dfa049a35fd8760e1923ba8.png)

---

<div class="post-metadata">

**Author:** ![atdt0](https://yyz2.discourse-cdn.com/free1/user_avatar/sleuthkit.discourse.group/atdt0/32/202_2.png) [@atdt0](https://sleuthkit.discourse.group/u/atdt0)\
**Post date:** [November 25, 2021, 11:22pm UTC](https://sleuthkit.discourse.group/t/convert-date-in-this-format-1498990899643994356-with-19-characters/2960/2 "2021-11-25T23:22:29Z")

</div>

Hi Ricardo.

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

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

```