Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

timezone

Values (Default in Bold)

UTC, time zone

Syntax

Copy
SET timezone { TO | = } [ time_zone | DEFAULT ] SET time zone [ time_zone | DEFAULT ]

Description

Sets the time zone for the current session. The time zone can be the offset from Coordinated Universal Time (UTC) or a time zone name.

Note

You can't set the timezone configuration parameter by using a cluster parameter group. The time zone can be set only for the current session by using a SET command or for all sessions run by a specific database user by using the ALTER USER command.

When you set the time zone using the SET timezone (one word) command with either TO or =, you can specify time_zone as a time zone name, a POSIX-style format offset, or an ISO-8601 format offset, as shown following.

Copy
SET timezone { TO | = } time_zone

When you set the time zone using the SET time zone command without TO or =, you can specify time_zone using an INTERVAL as well as a time zone name, a POSIX-style format offset, or an ISO-8601 format offset, as shown following.

Copy
SET time zone time_zone

Time Zone Formats

Amazon Redshift supports the following time zone formats:

  • Time zone name

  • INTERVAL

  • POSIX-style time zone specification

  • ISO-8601 offset

Because time zone abbreviations, such as PST or PDT, are defined as a fixed offset from UTC and don't include daylight savings time rules, the SET command doesn't support time zone abbreviations.

For more details on time zone formats, see the following.

Time Zone Name – The full time zone name, such as America/New_York. Full time zone names can include daylight savings rules.

The following are examples of time zone names:

  • Etc/Greenwich

  • America/New_York

  • CST6CDT

  • GB

Note

Many time zone names, such as EST, MST, NZ, and UCT, are also abbreviations.

To view a list of valid time zone names, run the following command.

Copy
select pg_timezone_names();

INTERVAL – An offset from UTC. For example, PST is –8:00 or –8 hours.

The following are examples of INTERVAL time zone offsets:

  • –8:00

  • –8 hours

  • 30 minutes

POSIX-Style Format – A time zone specification in the form STDoffset or STDoffsetDST, where STD is a time zone abbreviation, offset is the numeric offset in hours west from UTC, and DST is an optional daylight-savings zone abbreviation. Daylight savings time is assumed to be one hour ahead of the given offset.

POSIX-style time zone formats use positive offsets west of Greenwich, in contrast to the ISO-8601 convention, which uses positive offsets east of Greenwich.

The following are examples of POSIX-style time zones:

  • PST8

  • PST8PDT

  • EST5

  • EST5EDT

Note

Amazon Redshift doesn't validate POSIX-style time zone specifications, so it is possible to set the time zone to an invalid value. For example, the following command doesn't return an error, even though it sets the time zone to an invalid value.

Copy
set timezone to ‘xxx36’;

ISO-8601 Offset – The offset from UTC in the form ±[hh]:[mm].

The following are examples of ISO-8601 offsets:

  • -8:00

  • +7:30

Examples

The following example sets the time zone for the current session to New York.

Copy
set timezone = 'America/New_York';

The following example sets the time zone for the current session to UTC–8 (PST).

Copy
set timezone to '-8:00';

The following example uses INTERVAL to set the time zone to PST.

Copy
set timezone interval '-8 hours'

The following example resets the time zone for the current session to the system default time zone (UTC).

Copy
set timezone to default;