Postgres Pro
Downloads
Home   >   mailing lists

Re: missing epoch timestamps literals in examples - Mailing list pgsql-docs

From Tom Lane
Subject Re: missing epoch timestamps literals in examples
Date
Msg-id 1701189.1594214517@sss.pgh.pa.us
Whole thread Raw
In response to missing epoch timestamps literals in examples  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view 
PG Doc comments form <noreply@postgresql.org> writes:
> I am missing how to work with unix (date)time(stamps) from epoch, e.g.
> 1592203289.310 for 2020-06-15T06:41:29.31.

regression=# select to_timestamp(1592203289.310);
       to_timestamp        
---------------------------
 2020-06-15 02:41:29.31-04
(1 row)

            regards, tom lane

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: missing epoch timestamps literals in examples
Next
From: PG Doc comments form
Date:
Subject: initdb - creating clusters