Skip to content
DBCode

SYSTIMESTAMP

SYSTIMESTAMP() RETURN TIMESTAMP WITH TIME ZONE;

Section titled “SYSTIMESTAMP() RETURN TIMESTAMP WITH TIME ZONE;”

Example

Section titled “Example”
SELECT SYSTIMESTAMP FROM DUAL;

Output

Section titled “Output”
SYSTIMESTAMP
----------------------------------------------
27-JUL-20 14.53.49.567439000 -07:00

Explanation

Section titled “Explanation”

The SYSTIMESTAMP function in Oracle returns the current date and time of the system including fractional seconds and time zone. In the provided example, the function SYSTIMESTAMP is used to retrieve the current system timestamp from a dummy table DUAL.