Oracle DBTIMEZONE Function
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
The Oracle DBTIMEZONE function returns the database timezone offset of the database. It returns it in the format of +/- TZH:TZM, or the time zone region name.
It’s useful to know what timezone the database is in when working with dates and different time zones, as it can impact the queries you write.