Time Zone « Date Timezone « Oracle PL / SQL






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