LOCALTIMESTAMP function in Oracle

LOCALTIMESTAMP is one of the vital Date/Time functions of Oracle. It is used to get the current date and time in the time zone of the current SQL session. The LOCALTIMESTAMP function is similar as the CURRENT_TIMESTAMP function with the only difference that it returns a TIMESTAMP value instead of a TIMESTAMP WITH TIME ZONE values. The LOCALTIMESTAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.

Syntax:

LOCALTIMESTAMP 

Example:

Select LOCALTIMESTAMP
from dual;

Output:

26-Jun-19 11.48.14 PM 

Explanation: The result will be the local timestamp in the time zone of the current SQL session.

Please follow and like us:
Content Protection by DMCA.com