The SHOW TIME ZONE statement lists the default time zone for the current session.

Synopsis

SHOW TIME ZONE

Required Privileges

No privileges are required to view the default time zone.

Examples

> SET TIME ZONE 'EST';
> SHOW TIME ZONE;
+-----------+
| TIME ZONE |
+-----------+
| EST       |
+-----------+
(1 row)
> SET TIME ZONE DEFAULT;
> SHOW TIME ZONE;
+-----------+
| TIME ZONE |
+-----------+
| UTC       |
+-----------+
(1 row)

See Also



Yes No