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


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.

No comments:

Post a Comment