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;