PostgreSQL Get 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_ti Mestamp,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 ';

This article is from the "Yiyi" blog, make sure to keep this source http://heyiyi.blog.51cto.com/205455/1872904

PostgreSQL Get UNIX Timestamp