Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch

From:	Michael Paquier <michael(at)paquier(dot)xyz>
To:	Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Petr Fedorov <petr(dot)fedorov(at)phystech(dot)edu>
Subject:	Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch
Date:	2020-09-17 05:53:27
Message-ID:	20200917055327.GU2873@paquier.xyz
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2019-11-30 09:28:18 from Petr Fedorov <petr(dot)fedorov(at)phystech(dot)edu>  2019-11-30 15:21:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>  2019-12-01 22:50:00 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>   2019-12-01 22:59:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2019-12-02 11:08:43 from Petr Fedorov <petr(dot)fedorov(at)phystech(dot)edu>     2019-12-02 22:52:31 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>      2020-05-25 13:28:54 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>       2020-05-25 13:43:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2020-05-25 19:29:21 from David Fetter <david(at)fetter(dot)org>       2020-05-25 16:01:07 from Vik Fearing <vik(at)postgresfriends(dot)org>        2020-05-25 16:40:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2020-05-25 16:52:01 from Vik Fearing <vik(at)postgresfriends(dot)org>          2020-05-25 17:07:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2020-05-25 17:35:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2020-10-31 23:57:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎             2020-11-02 22:50:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎              2020-11-04 00:22:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎               2021-06-06 06:33:31 from Noah Misch <noah(at)leadboat(dot)com>                2021-06-06 14:37:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2021-06-06 16:38:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2021-06-06 19:10:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2021-06-08 05:31:55 from Noah Misch <noah(at)leadboat(dot)com>       2020-08-04 14:08:07 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> 📎        2020-08-04 14:21:56 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>         2020-08-12 07:04:07 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> 📎          2020-09-06 23:46:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎           2020-09-07 03:46:57 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>           2020-09-09 08:08:06 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>            2020-09-09 13:38:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2020-09-09 18:47:36 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>              2020-09-17 05:53:27 from Michael Paquier <michael(at)paquier(dot)xyz>               2020-09-30 07:15:43 from Michael Paquier <michael(at)paquier(dot)xyz>                2020-12-15 14:03:31 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> 📎                 2021-03-15 12:18:29 from David Steele <david(at)pgmasters(dot)net>                  2021-03-15 17:35:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2021-03-18 08:28:38 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                    2021-03-19 19:37:04 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> 📎                     2021-03-19 20:06:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2021-03-22 20:58:20 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> 📎                       2021-03-23 20:52:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                      2021-04-01 18:49:45 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> 📎                       2021-04-06 05:48:21 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                       2021-04-19 15:57:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2021-04-22 20:26:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                         2021-04-27 15:56:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2021-04-28 05:43:27 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                           2021-04-28 13:43:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:	pgsql-bugs pgsql-hackers

In response to

• Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch at 2020-09-09 18:47:36 from Peter Eisentraut

Responses

• Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch at 2020-09-30 07:15:43 from Michael Paquier

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	RECHTÉ Marc	2020-09-17 06:38:10	Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values
Previous Message	Pavel Stehule	2020-09-17 03:49:14	Re: Strange output of XML attribute values

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Michael Paquier	2020-09-17 05:55:31	Re: list of extended statistics on psql
Previous Message	Michael Paquier	2020-09-17 05:47:40	Re: fixing old_snapshot_threshold's time->xid mapping