Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 32 of 166
dbtimezone::=
dbtimezone
The DBTIMEZONE
function returns the value of the database time zone. The return type is 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.
The following example assumes that the database time zone is set to UTC time zone:
SELECT DBTIMEZONE FROM DUAL; DBTIME ------ -08:00
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|