The Oracle docs note the syntax for the Oracle CURRENT_TIMESTAMP
function as follows:
CURRENT_TIMESTAMP [ (precision) ]
The Oracle CURRENT_TIMESTAMP
function returns the
current TIMESTAMP WITH TIME ZONE within the sessions time zone. The Oracle CURRENT_TIMESTAMP
function is similar to the Oracle SYSTIMESTAMP function. The
precision to which the TIMESTAMP is returned can be specified. If no precision is specified, the default is
6.
select
current_timestamp(3)
from
dual;
CURRENT_TIMESTAMP(3)
-----------------------------
10-JUL-04
19.11.12.686 +01:00
1 row selected.
For more information on Oracle CURRENT_TIMESTAMP as well as other
timestamp functions,
see
here.
