TZ_OFFSET

The TZ_OFFSET function returns the time zone of the argument as of the date the statement is executed. Timezone region names are required by daylight savings features.

Syntax

TZ_OFFSET ({ 'time_zone_name' | '{ + | - } hh : mi'})

Remarks

•

The time_zone_name argument can be a time zone name or an offset from UTC (which returns itself).

•

TDV does not accept the argument SESSIONTIMEZONE or DBTIMEZONE.

•

For a list of time zone names, see Time Zones

Example

SELECT TZ_OFFSET ('US/Eastern');

This example returns a result that looks like this:

TZ_OFFSET('US/Eastern')

-04:00