Time, TIMETZ, Timestamp and TimestampTZ in PostgreSQL
Blog post from Cockroach Labs
This blog post delves into the intricacies of time data types in PostgreSQL, including TIME, TIMETZ, TIMESTAMP, and TIMESTAMPTZ. It covers topics such as session time zones, POSIX time offsets, parsing, casting, precision, functions and operators, AT TIME ZONE, daylight savings, interval math with daylight savings, the Y2K38 problem, and more. The author recommends using TIMESTAMPTZ with a session time zone set to UTC for handling time data types in PostgreSQL.
No tracked trend matches for this post yet.
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.