I'm not sure this exactly is what I'm thinking about. Yes, `at time zone "UTC"` does the proper conversion, so all times will represent the exact instant they s

I'm not sure this exactly is what I'm thinking about. Yes, `at time zone "UTC"` does the proper conversion, so all times will represent the exact instant they should. But in no cases do you know what time zone the data came in as -- that information is thrown away. When you look at your data, what is the time a user's watch said when the data was input? What time zone was the data input as? Here's some queries: create table tz_test ( comment varchar, ts_tz timestamptz ); insert into tz_test (comment, ts_tz) values ('midnight US Eastern', timestamp with time zone '2025-05-13 00:00:00-4'), ('4am UTC', timestamp with time zone '2025-05-13 04:00:00+0'); select comment, ts_tz from tz_test; I would expect that one row comes out as midnight, and the other row comes out as 4am. But they both come out as midnight. That's what I don't like.