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.

Possibly related:

Tagged | Post a Comment