To determine the time zone under which a database was operating?

Options
- select DBTIMEZONE from root
- select TIMEZONE_DB from dual
- select DB_TIME_ZONE from dual
- select DBTIMEZONE from dual


CORRECT ANSWER : select DBTIMEZONE from dual

Discussion Board
ORACLE SQL

very soft and nice tooooo

IBRAHIM MUHAMMAD 01-13-2019 08:46 AM

DBTIMEZONE

DBTIMEZONE is a function which returns the current value of Database Time Zone. It can be queried using the example below:

SELECT DBTIMEZONE FROM DUAL;

DBTIME
------
+00:00

Please note the return type of function is Time Zone Offset. The format ([+|-] TZH: TZM) contains the lead (+) and lag (-) with hour and minutes specifications.

Prajakta Pandit 02-9-2017 12:03 AM

test

happy

kiran 03-16-2015 09:16 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement