Unix Timestamp Converter

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

// 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')

// current ts in milliseconds:
System.currentTimeMillis();
// in seconds
System.currentTimeMillis() / 1000;

# current ts in milliseconds:
import time
int(time.time() * 1000)
# in seconds
int(time.time())

// timestamp to human
unixtime_milliseconds_todatetime(milliseconds)