Skip to content
The Chat Archive
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?…

  1. User

    This timestamp comes from chrome's downloads table. How do I convert it to a date? 13394428751714014

  2. Assistant

    Chrome stores download times as “WebKit timestamps,” i.e. microseconds since 1601-01-01 UTC. To turn one into a normal date you:

    1. Subtract the epoch‐difference between 1601 and 1970: Δ = 11644473600 seconds
    2. Divide by 1 000 000 to go from microseconds → seconds
    3. Feed the result into whatever date‐function you like

    Here are three recipes:

    1. 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
    
    1. 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()); 
    
    1. 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.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.