DBTIMEZONE

DBTIMEZONE returns the value of the database time zone as either a time zone offset from Coordinated Universal Time (UTC) or a time zone region name.

To obtain other time zone offsets, use TZ_OFFSET.

Return Value

VARCHAR2

Syntax

DBTIMEZONE

Example

DBTIMEZONE returns the offset -08:00 for Mountain Standard Time.