Oracle TZ_OFFSET function
Description
The TZ_OFFSET() is used to get the time zone offset corresponding to the argument based on the date the statement is executed.
Syntax:
TZ_OFFSET({ 'time_zone_name' | '{ + | - } hh : mi' | SESSIONTIMEZONE | DBTMEZONE } )
Parameters:
Name | Description |
---|---|
TZ_OFFSET | A valid time zone. You can enter a valid time zone name, a time zone offset from UTC, or the keyword SESSIONTIMEZONE or DBTIMEZONE. See the valid Time Zone Region Names list from here. |
Applies to:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i
Example: Oracle TZ_OFFSET function
The following statement returns the time zone offset of the Africa/Abidjan time zone from UTC:
SQL> SELECT TZ_OFFSET('Africa/Abidjan') FROM DUAL;
Sample Output:
TZ_OFFS ------- +00:00
Previous:
TRUNC(date)
Next:
Oracle-character-functions Introduction
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework