DBTIMEZONE

The DBTIMEZONE function returns the value of the database time zone.

Return Values

A time zone offset (a character type in the format '[+|-]TZH:TZM') or a time zone region name, depending on how the user specified the database time zone value in the most recent CREATE DATABASE or ALTER DATABASE statement.

Syntax

DBTIMEZONE

Examples

Example 7-62 Retrieving the Database Time Zone

SHOW DBTIMEZONE
-08:00