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

Filed in Oracle, Tips on 30 Jun 05

---