Why is Trino truncating six digits of nanoseconds, leaving only milliseconds?
The Trino documentation gives the following example:
SELECT from_iso8601_timestamp_nanos('2020-05-11T11:15:05.123456789+01:00');
-- 2020-05-11 11:15:05.123456789 +01:00
However, when I run this same statement on Trino, I get the following:
SELECT from_iso8601_timestamp_nanos('2020-05-11T11:15:05.123456789+01:00');
-- 2020-05-11 06:15:05.123 -04:00
I'm not concerned with the timezone adjustment; I'm concerned with the loss of precision of the timestamp.
Why am I losing this precision?
Is there another way to retain this precision?