Oracle time zones
A couple of nice-to-know queries:
SELECT SESSIONTIMEZONE FROM DUAL;
returns the time zone of the client session.
SELECT DBTIMEZONE FROM DUAL;
returns the time zone of the database server.
Related articles:
- Give Me The Current Date Please
- Oracle Database 11g Old Feature: Internet Addressing
- One more reason to upgrade your Oracle 8i
