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:


Tagged | Comments Closed | Trackbacks Closed