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.