In Oracle/PLSQL, the systimestamp function returns the current system date and time (including fractional seconds and time zone) on your local database.
Syntax
The syntax for the systimestamp function is:
systimestamp
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i
For Example
select systimestamp
from dual;
The systimestamp 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