Database Time Zone

The database time zone is controlled using the TIME_ZONE database parameter. The command to change the database time zone is:

ALTER DATABASE SET TIME_ZONE = '-8:00' 
ALTER DATABASE SET TIME_ZONE = 'PST'

To get the database time zone using the DBTIMEZONE function.

SELECT DBTIMEZONE 
FROM dual;

1. What is Time Zone
2. Database Time Zone
3. Session Time Zone
4. Time Zone Names