A few tools, each one explained properly
A working engineer's toolbox. Not the hundredth Base64 encoder — each tool takes a problem you hit occasionally and have to re-learn every time, explains how it actually works, and gives you something that computes.
Drag the data distribution on the left; watch which path Postgres picks on the right — and how far you are from a different answer.
Paste anything with a time hidden in it. The tool works out what it is and shows you which bits hold the timestamp.