Unix Timestamp Converter

Current unix timestamp

Seconds

Milliseconds

Convert timestamp to human-readable date and time

Supports Unix timestamps in seconds, milliseconds

Human-readable date and time to timestamp

Frequent unix timestamps
	seconds	milliseconds
now	1749846069	1749846069389
24 hours ago	1749759669	1749759669389
1 week ago	1749241269	1749241269389

Language specific tips

Presto

--timestamp in seconds to human readable date
select from_unixtime(tx_date, 'America/Los_Angeles') as tx_date from transactions;

Javascript

// current ts in milliseconds:
Date.now()
// in seconds
Math.round(Date.now() / 1000)
// to human readable
new Date().toLocaleString()
// from string to timestamp
Date.parse('11/15/2020, 11:03:44 PM')