Re: [Squirrel-sql-users] PostgreSQL timestamp with time zone does not display the zone

[John H. <jh...@im...>]

On Thu, 10 Sep 2026, info via Squirrel-sql-users wrote:

> It is probably technically correct that Squirrel displays the local timestamp 
> for timestamp with time zone, but it misses the point of the intent: when the 
> time zone is part of the data type, the intent is to see the zone, especially 
> through the SQL client when querying the DB, which may be a different intent 
> from doing it in the back-end code. So I am going to put this out there: 
> probably Squirrel should display the TZ instead of converting to the local 
> time.

+1

A query tool should not mutate the retrieved data in that manner.

Possibly: a context menu option for DTM-type data to display it converted 
to the local TZ, temporarily by cell or a toggle for the column.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...                         pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
  Tomorrow: the 25th anniversary of 9/11