Timestamp tools
Last modified: June 1, 2023
Current Unix Timestamp
Convert timestamp to human-readable date and time
Supports Unix timestamps in seconds, milliseconds
Human-readable date and time to timestamp
Frequently used timestamps
seconds | milliseconds | |
---|---|---|
now | 1715020750 | 1715020749796 |
24 hours ago | 1714934350 | 1714934349796 |
1 week ago | 1714415950 | 1714415949796 |
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')