Select the current time zone : Time Zone « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. Time Zone

Select the current time zone


SQL>
SQL> select dbtimezone from dual;

DBTIME
------
+00:00

SQL>








Related examples in the same category

1.Time zone name
2.Timestamp with local time zone as a table column
3.Time change from Chicago to Los Angeles(Central to Pacific)
4.Obtaining Time Zone Names
5.ALTER SESSION statement sets the local time zone to Pacific Standard Time (PST)
6.TIME_ZONE to EST and get CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP