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';

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.

Leave a Reply

avatar
  Subscribe  
Notify of