How can I convert a "timestamp_usec" number, such as 1364774098689591 to an actual date/time?

I downloaded my entire Google Search history. With each archived internet search (JSON File), Google includes a piece of meta-information called the "timestamp_usec."

I've found a few websites that do it for me, but I can't for the life of me find a JavaScript formula that will do it, or an explanation of how it's done.

I've found a few "unix timestamp" converters, but they don't seem to work on this "Timestamp_USEC," as it appears to be a different format.

Thanks!

How can I convert a "timestamp_usec" number, such as 1364774098689591 to an actual date/time?

I downloaded my entire Google Search history. With each archived internet search (JSON File), Google includes a piece of meta-information called the "timestamp_usec."

I've found a few websites that do it for me, but I can't for the life of me find a JavaScript formula that will do it, or an explanation of how it's done.

I've found a few "unix timestamp" converters, but they don't seem to work on this "Timestamp_USEC," as it appears to be a different format.

Thanks!

• javascript
• timestamp
• unix-timestamp

Share Improve this question Follow asked Sep 30, 2016 at 19:06 Lukas UdstuenLukas Udstuen 5511 silver badge66 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 6

It's not a "different format". It's just a conventional unix timestamp in microseconds, which means you can use the TRIVIAL conversion:

var d = new Date(1364774098689591 / 1000);

to load it up. JS Date() expects milliseconds (among other formats), and microseconds = milliseconds * 1000, after all...