ALTER TIME ZONE statement

Modifies a time zone object.

Syntax

ALTER TIME ZONE name time-zone-option [ ... ]

time-zone-option : 
 { OFFSET offset
 | DST OFFSET offset
 | NO DST
 | [ DST ] STARTING month-day-rule AT { minutes | hours:minutes }
 | [ DST ] ENDING month-day-rule AT { minutes | hours:minutes } }

Remarks

All clauses are optional; however, if none are present, then the statement fails.

If you are adding daylight savings time to a time zone that previously had no daylight savings time, then use the STARTING and ENDING clauses. If you are removing daylight savings time from a time zone, then specify the NO DST clause and omit the STARTING and ENDING clauses.

Privileges

You must have the MANAGE TIME ZONE system privilege or the ALTER ANY OBJECT system privilege.

Side effects

Automatic commit.

Executing this statement populates the ISYSTIMEZONE system table.

Example

To change the time zone named EasternTime, which uses daylight savings time, to use Australian Eastern Time without daylight savings time, execute the following statement:

ALTER TIME ZONE EasternTime OFFSET '10:00'
NO DST;