SYSTIMESTAMP

SYSTIMESTAMP is an SQL function that returns the current system timestamp with time zone information. It represents the date, time of day, and time zone of the system where the SQL Server instance is running. The fraction precision of the seconds is up to 9 decimal places. The return type is TIMESTAMP WITH TIME ZONE.

SYSTIMESTAMP() RETURN TIMESTAMP WITH TIME ZONE;

Example

SELECT SYSTIMESTAMP FROM DUAL;

Output

SYSTIMESTAMP
----------------------------------------------
27-JUL-20 14.53.49.567439000 -07:00

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.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.