| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | hans(at)matfyz(dot)cz |
| Subject: | missing epoch timestamps literals in examples |
| Date: | 2020-07-08 12:47:18 |
| Message-ID: | 159421243860.16544.17954911309198958049@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/datatype-datetime.html
Description:
Thank you for lot of examples about date, time an timestamp.
I am missing how to work with unix (date)time(stamps) from epoch, e.g.
1592203289.310 for 2020-06-15T06:41:29.31.
How to directly insert unix ts literal into timezone column?
INSERT INTO table VALUES ('epoch'::timestamptz + 1592203289.310 * '1
second'::interval), (to_timestamp(1395036000) AT TIME ZONE 'UTC');
https://www.postgresonline.com/journal/archives/3-Converting-from-Unix-Timestamp-to-PostgreSQL-Timestamp-or-Date.html
https://stackoverflow.com/questions/34901804/how-work-with-unix-timestamp-on-postgresql
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-07-08 13:21:57 | Re: missing epoch timestamps literals in examples |
| Previous Message | murali maheswaram | 2020-07-08 06:59:06 | Request for TDE Implementation Doc for Centos |