Understanding Time Zones : Timezone « SQL Data Types « Oracle PL/SQL Tutorial






A time zone is an offset from the time in Greenwich, England.

The time in Greenwich was once known as Greenwich Mean Time (GMT).

It is now known as Coordinated Universal Time.

You specify a time zone using either an offset from UTC or the name of the region.

When you specify an offset, you use HH:MI prefixed with a plus or minus sign:

+|-HH:MI

where

  1. + or - indicates an increase or decrease for the offset from UTC.
  2. HH:MI indicates the time zone hour and minute for the offset.

You may also specify a time zone using the name of a region.

For example, PST indicates Pacific Standard Time, which is seven hours behind UTC.

EST indicates Eastern Standard Time, which is four hours behind UTC.

Quote from:

Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

# Paperback: 608 pages

# Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)

# Language: English

# ISBN-10: 0072229810

# ISBN-13: 978-0072229813

10.13.Timezone
10.13.1.Understanding Time Zones
10.13.2.Time Zone-Related Functions
10.13.3.The Database Time Zone and Session Time Zone
10.13.4.Change timezone