Oracle Date/Time Function - Oracle/PLSQL SYSTIMESTAMP Function

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

The Oracle/PLSQL SYSTIMESTAMP function returns the current system date and time including fractional seconds and time zone.

SYSTIMESTAMP returns a TIMESTAMP WITH TIME ZONE for the database.

Syntax

The syntax for the Oracle/PLSQL SYSTIMESTAMP function is:

SYSTIMESTAMP

There are no parameters or arguments for the SYSTIMESTAMP function.

Example


SQL> SELECT SYSTIMESTAMP FROM dual;
-- from w ww.  j av a 2 s. c  om
SYSTIMESTAMP
---------------------------------------------
08-JUL-12 10.23.09.087000 AM -07:00

SQL>
SQL> ALTER SESSION SET TIME_ZONE = 'EST';

Session altered.

SQL>
SQL> SELECT SYSTIMESTAMP FROM dual;

SYSTIMESTAMP
---------------------------------------------
08-JUL-12 10.23.09.134000 AM -07:00

SQL> ALTER SESSION SET TIME_ZONE = 'PST';

Session altered.

SQL>
SQL> SELECT SYSTIMESTAMP FROM dual;

SYSTIMESTAMP
---------------------------------------------
08-JUL-12 10.23.09.790000 AM -07:00

SQL>