Time zone name : Time Zone « Date Timezone « Oracle PL / SQL






Time zone name

 
Time Zone      Description

AST (ADT)      Atlantic Standard (or Daylight Time)

BST (BDT)      Bering Standard (or Daylight Time)

CST (CDT)      Central Standard (or Daylight Time)

EST (EDT)      Eastern Standard (or Daylight Time)

GMT            Greenwich Mean Time

HST (HDT)      Alaska-Hawaii Standard Time or Daylight Time

MST (MDT)      Mountain Standard or Daylight Time

NST            Newfoundland Standard Time

PST (PDT)      Pacific Standard or Daylight Time

YST (YDT)      Yukon Standard or Daylight Time

--

 








Related examples in the same category

1.Select the current time zone
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