If your session time zone is not US/Central Standard Time (-06:00), alter your session to Central Standard time: : Timezone « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. Timezone
SQL>
SQL>
SQL> alter session set time_zone = '-06:00';

Session altered.

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: