How to find my current database TIME ZONE in oracle pl/sql

You are here : Home / Database Tutorials / Oracle PL/SQL tutorials

In this oracle tutorial we will learn how to find current database TIME ZONE  in Oracle pl/sql.

You can find current database TIME ZONE in oracle Pl/sql using Oracle reserved keyword CURRENT_TIMESTAMP, SYSTIMESTAMP and SESSIONTIMEZONE.

How to find my current database TIME ZONE in oracle pl/sql?

Use either of the following -

select CURRENT_TIMESTAMP from dual;

select SYSTIMESTAMP from dual;

Or, simple way is to use

SELECT SESSIONTIMEZONE FROM dual;

So in this oracle tutorial we learned how to find current database TIME ZONE  in Oracle pl/sql.

Labels: Oracle