1 Answer
- Newest
- Most votes
- Most comments
0
Hi From PostgreSQL doc: https://www.postgresql.org/docs/10/functions-datetime.html
to_timestamp(double precision)
examples in the link indicating something like:
SELECT to_timestamp(982384720.12); Result: 2001-02-17 04:38:40.12+00
Your data to_timestamp(164441704.153) seems to have one more precision.
Relevant content
- asked 5 months ago
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 7 months ago