Determine the database time zone: : Timezone « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. Timezone
SQL> select dbtimezone from dual;



DBTIME
------
+00:00

1 row selected.

SQL>
SQL>
SQL>








29.27.Timezone
29.27.1.Alter session to change the time zone
29.27.2.Determine the database time zone:
29.27.3.Determine your session time zone:
29.27.4.Adjust your session time zone to -08:00
29.27.5.If your session time zone is not US/Central Standard Time (-06:00), alter your session to Central Standard time: