• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / Oracle DBTIMEZONE Function

Oracle DBTIMEZONE Function

November 5, 2012 by techhoneyadmin

Oracle DBTIMEZONE FunctionOracle DBTIMEZONE Function is used to get the data-base time zone as a time zone offset or even as a time zone region name.


Oracle DBTIMEZONE Function Syntax

SELECT DBTIMEZONE
FROM table_name;

Oracle DBTIMEZONE – Using SQL SELECT Example

Oracle DBTIMEZONE can be used with the SQL SELECT Statement.

For example, the below query returns the data base time zone or time zone offset.

SELECT DBTIMEZONE
FROM DUAL;

May return “+00:00”
Or it may return “:+5:30”

Depending upon the time zone value set in the Oracle data-base


Filed Under: function Tagged With: dbtimezone function in oracle plsql, dbtimezone function in oracle sql, DBTIMEZONEPLSQL, how to use dbtimezone function in oracle database query, how to use dbtimezone function in oracle plsql, how to use dbtimezone function in oracle sql, syntax and example of dbtimezone function in oracle database query, syntax and example of dbtimezone function in oracle plsql, syntax and example of dbtimezone function in oracle sql, using dbtimezone function in oracle database query, using dbtimezone function in oracle plsql, using dbtimezone function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in