SQL Current Date Function

0

To return the current date in Oracle Database, use;

SELECT
  CURRENT_DATE
FROM
  DUAL;

To get the Session Time zone;

SELECT
  SESSIONTIMEZONE
FROM
  DUAL;

If you want to change the time zone of your Oracle database;

ALTER SESSION SET TIME_ZONE = '-09:00';

0 0 vote
Article Rating

I am a Cloud Solutions Engineer working with a leading cloud solutions company. I have more than 5 years’ experience in the Tech ecosystem. I began my career as a software developer. I am a tech enthusiast, an autodidact whose interests includes Data Management, Cloud Native Development, Mobile and Bots Development, Integration, Low Code Development, AI, Analytics just to say the least.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments