Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch
Thomas Munro <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <CA+hUKGKgHUbFNKRhvodn4mVU-oqje+HA7jTg_XrWRo4UGhFoqg@mail.gmail.com> |
On Sat, Nov 30, 2019 at 10:28 PM Petr Fedorov <[email protected]> wrote: > Obviously, it is due to the fact that extract epoch returns double > precision which in turn has 15 decimal digits precision. I guess this deviation from the SQL standard ("exact numeric") made sense when PostgreSQL used double for timestamps, but would break a lot of queries if we changed it.