Reference Guide > TDV Support for SQL Functions > TDV-Supported Date Functions > TZ_OFFSET
 
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