Add the unix_timestamp and from_unixtime functions of MySQL to PostgreSQL.

Two common functions of MySQL, unix_timestamp () and from_unixtime PostgreSQL, are not provided, but they can be easily solved through the powerful scalability of PostgreSQL.

The words are far away from the sky, and the documents are carefully read. PostgreSQL provides epoch for extract and date_part.
That is
Unix_timestamp () = round (date_part ('epoch', now ()))
From_unixtime (int) = to_timestamp (int)

Add function unix_timestamp ()
Create function unix_timestamp () RETURNS integer AS $
SELECT (date_part ('epoch', now (): integer;
$ Language SQL IMMUTABLE;

Add function from_unixtime ()
Create function from_unixtime (int) RETURNS timestamp AS $
SELECT to_timestamp ($1): timestamp;
$ Language SQL IMMUTABLE;

 

From: http://www.jiangmiao.org/blog/430.html