o4-mini-2025-04-16· OpenAI LMArena Human Preference 140K
This timestamp comes from chrome's downloads table. How do I convert it to a date?…
- User
This timestamp comes from chrome's downloads table. How do I convert it to a date? 13394428751714014
- Assistant
Chrome stores download times as “WebKit timestamps,” i.e. microseconds since 1601-01-01 UTC. To turn one into a normal date you:
- Subtract the epoch‐difference between 1601 and 1970: Δ = 11644473600 seconds
- Divide by 1 000 000 to go from microseconds → seconds
- Feed the result into whatever date‐function you like
Here are three recipes:
- Python
import datetime wk_ts = 13394428751714014 # WebKit time = µs since 1601-01-01 unix_ts = wk_ts/1_000_000 - 11644473600 dt = datetime.datetime.utcfromtimestamp(unix_ts) print(dt) # e.g. 2025-06-30 12:34:11.714014- JavaScript (Node or browser—using BigInt for safety):
const wk = 13394428751714014n; const EPOCH_DIFF_US = 11644473600n * 1000000n; // convert to µs then subtract const unix_ms = Number((wk - EPOCH_DIFF_US) / 1000n); const d = new Date(unix_ms); console.log(d.toISOString());- SQLite
SELECT datetime( (start_time/1000000.0) -- → seconds since 1601 - 11644473600.0, -- subtract epoch diff 'unixepoch' ) AS download_utc FROM downloads;All of these will yield a UTC timestamp for your download record.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.