Oracle CURRENT_TIMESTAMP function.

Preamble

Oracle/PLSQL CURRENT_TIMESTAMP function returns the current date and time in the time zone of the current SQL session as set with the ALTER SESSION command. It returns the date/time with the time zone value.

Oracle/PLSQL syntax of CURRENT_TIMESTAMP function

CURRENT_TIMESTAMP

Parameters and function arguments

• There are no parameters or arguments for the function CURRENT_ TIMESTAMP.

The function CURRENT_TIMESTAMP returns the value TIMESTAMP WITH TIME ZONE.

The LOCALTIMESTAMP function similar to CURRENT_TIMESTAMP.

The difference between these two functions is that CURRENT_TIMESTAMP returns a date/time with a time zone value, while LOCALTIMESTAMP returns a date/time value.

The CURRENT_TIMESTAMP function can be used in the following Oracle/PLSQL versions

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i

 

Let’s consider some examples of the CURRENT_TIMESTAMP function and learn how to use CURRENT_TIMESTAMP in Oracle.

If you execute the ALTER SESSION command:

ALTER SESSION SET TIME_ZONE = '-3:0';

And execute the next SQL query:

select CURRENT_TIMESTAMP from dual;

You will get the following result:

30.07.14 16:16:37,119993 -03:00

Then you will change the time zone with the ALTER SESSION command:

ALTER SESSION SET TIME_ZONE = '-7:0';

And execute the next SQL query:

select CURRENT_TIMESTAMP from dual;

You will get the following result:

30.07.14 9:16:37,119993 -07:00

The time zone of the session has changed from -3:0 to -7:0, as a result of which CURRENT_TIMESTAMP function will return the current date and time to the past by 4 hours.

The Oracle CURRENT_TIMESTAMP function will display the current date and time in the session time zone

 

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​