Time to Better Know The Time in PostgreSQL

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

To honor the name of the site (boringSQL) let's deep dive into a topic which might sound obvious, but it might be never ending source of surprises and misunderstanding. Simple things We can start with the simple statement like SELECT '2025-03-30 00:30' as t; Result: t ------------------ 2025-03-30 00:30 which gives you (and I do hope that's not a big surprise) a simple text literal,…

Read on boringsql.com ↗