DBTIMEZONE

Syntax

DBTIMEZONE()
RETURNS text;

Overview

The dbtimezone function returns the server's default time zone in text.

Internally, it looks at the pg_db_role_setting table to determine the settings for the current database.

If it doesn't exist, it will get the default TimeZone value from pg_settings.

In other words, it views the default time zone set on the server and provides it as a string.

Example

select oracle.dbtimezone();

 dbtimezone 
------------
 Asia/Seoul
(1 row)