Postgresql gets Unix timestamp
-- timestamp to unix timestamp
Select now (), EXTRACT (EPOCH FROM TIMESTAMP WITH TIME ZONE 'now ()):: int as ext, extract (epoch FROM now ()):: int, CURRENT_TIMESTAMP,date_part (' epoch',CURRENT_TIMESTAMP):: int
-- unix timestamp to timestamp
SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL' 1 second'
-- SELECT TIMESTAMP WITH TIME ZONE 'epoch' + extract (epoch FROM now ()) * INTERVAL' 1 second'
