Oracle Date/Time Function - Oracle/PLSQL LOCALTIMESTAMP Function






The syntax for the Oracle/PLSQL LOCALTIMESTAMP function is:

LOCALTIMESTAMP

LOCALTIMESTAMP returns a TIMESTAMP for the session.

LOCALTIMESTAMP function returns a TIMESTAMP value while the CURRENT_TIMESTAMP function returns a TIMESTAMP WITH TIME ZONE value.

Syntax

This Oracle tutorial explains how to use the Oracle/PLSQL LOCALTIMESTAMP function.

The Oracle/PLSQL LOCALTIMESTAMP function returns the current date and time in the time zone of the current SQL session. It returns a TIMESTAMP value.

Example


SQL> SELECT LOCALTIMESTAMP FROM dual;
-- from w  w w.j a  v  a2s. com
LOCALTIMESTAMP
-----------------------------------------------
08-JUL-12 10.21.19.837000 AM

SQL> ALTER SESSION SET TIME_ZONE = 'EST';

Session altered.

SQL> SELECT LOCALTIMESTAMP FROM dual;

LOCALTIMESTAMP
-----------------------------------------------
08-JUL-12 01.21.19.868000 PM

SQL> ALTER SESSION SET TIME_ZONE = 'PST';

Session altered.

SQL> SELECT LOCALTIMESTAMP FROM dual;

LOCALTIMESTAMP
-----------------------------------------------
08-JUL-12 10.21.21.509000 AM

SQL>




Fractional zone

LOCALTIMESTAMP(t) can have parameter: t. t is local time zone's fractional second precision. Ranges between 0 and 9. Optional; defaults to 6.


SQL> SELECT LOCALTIMESTAMP(4) FROM   DUAL;

LOCALTIMESTAMP(4)
--------------------------------------------
08-JUL-12 10.22.11.2270 AM

SQL>