Oracle/PLSQL: SysTimestamp function

In Oracle/PLSQL, the systimestamp function returns the current system date and time (including fractional seconds and time zone) on your local database.

The syntax for the systimestamp function is:

systimestamp

Applies To:

Oracle 9i, Oracle 10g, Oracle 11g

For example:

select systimestamp
from dual;

The systimezone function might return a value like this:

03-11-21 20:4

You can also choose to use the to_char function with the systimestamp function. For example:

select to_char(systimestamp, 'SSSS.FF')
from dual;

The function above may return a value such as:

4141.550774