DBTIMEZONE
DBTIMEZONE()
Section titled “DBTIMEZONE()”Example
Section titled “Example”SELECT DBTIMEZONE FROM DUAL;Output
Section titled “Output”+08:00Explanation
Section titled “Explanation”The DBTIMEZONE function in Oracle is used to get the database time zone offset. The above example SQL query when executed fetches the current timezone of the database. The result ‘+08:00’ indicates that the database is 8 hours ahead of Coordinated Universal Time (UTC).