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

[Gerd W. <ger...@t-...>]

On 9/10/26 17:38, 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.
> 
> Regards, Al
> 

the following was implemented and will be available in future snapshots
and versions:

Excerpt from change log:

> TIMESTAMP/TIME columns "with time zone" are now rendered in ISO format.
>   E.g. "2026-09-26T20:57:16-04:00" for a TIMESTAMP instance in time zone "America/New_York"
>   and "21:03:19+02:00" for a TIME instance in time zone "Africa/Johannesburg"="Europe/Berlin".


Gerd