WebKit/Chrome Timestamp convert into Ruby/Rails

Question

How to convert WebKit/Chrome Timestamp into Ruby/Rails.

Here is the timestamp data from Chrome excel 13130755192116927 but how I convert into the human-readable format using Ruby/Rails.

I have found some examples like How to convert a unix timestamp (seconds since epoch) to Ruby DateTime? but this data length is 13 & my data length is 17.

How I achieve that as like this WebKit/Chrome Timestamp Converter.

GMT: Sunday, February 5, 2017 7:59:52 AM

Thanks.

D1ceWard · Accepted Answer · 2018-09-21T09:58:40.027

2

From this question

Google timestamp is formatted as the number of microseconds since January, 1601

So here an Ruby example :

require 'date'

chrome_timestamp = 13130755192116927

# Get the January 1601 unixepoch
since_epoch = DateTime.new(1601,1,1).to_time.to_i

# Transfrom Chrome timestamp to seconds and add 1601 epoch
final_epoch = (chrome_timestamp / 1000000) + since_epoch

# Print DateTime
date = DateTime.strptime(final_epoch.to_s, '%s')

# without formating
puts date
=> '2017-02-05T07:59:52+00:00'

# with formating
puts date.strftime('%A, %B %-d, %Y %-I:%M:%S %p')
=> 'Sunday, February 5, 2017 7:59:52 AM'

edited Sep 21 '18 at 09:58

answered Sep 21 '18 at 08:29

D1ceWard

972
8
17

Could you suggest me please how I get as like this `Sunday, February 5, 2017 7:59:52 AM` – user9769384 Sep 21 '18 at 08:40
In the https://www.epochconverter.com/webkit showing `7:59:52 AM` but in your code, it's showing `07:50:31+00:00`, please advise – user9769384 Sep 21 '18 at 08:49
@user9769384 Try this `DateTime.strptime(final_epoch.to_s, '%s').strftime("%A, %B %-d, %Y %-l:%M:%S %p")`. Basically I just added a method that converts it to your desired format. – dcangulo Sep 21 '18 at 09:46
Fixed, I was using Date.new instead of DateTime.new, now it return the correct date and i added formating example – D1ceWard Sep 21 '18 at 10:00
Thanks & I will check this soon – user9769384 Sep 21 '18 at 11:02
OMG! you can & finally I passed the complexity – user9769384 Sep 21 '18 at 11:08
It was my first post about this https://stackoverflow.com/questions/52436374/convert-to-ruby-code-based-on-python-code-snippet – user9769384 Sep 21 '18 at 11:10

WebKit/Chrome Timestamp convert into Ruby/Rails

1 Answers1