Determine your session time zone: : SESSIONTIMEZONE « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. SESSIONTIMEZONE

Determine your session time zone:

   
SQL>
SQL> select sessiontimezone from dual;



SESSIONTIMEZONE
------------------------------------------------------
-08:00

1 row selected.

SQL>








Related examples in the same category

1.Get your session time zone using the SESSIONTIMEZONE() function
2.Adjust your session time zone to -08:00