Oracle Current Timestamp: SYSTIMESTAMP Guide

In Oracle, you can use the SYSTIMESTAMP function to retrieve the current timestamp, including both date and time. This function returns a timestamp that includes timezone information and can be accurate up to the nanosecond level.

The basic grammar is as follows:

SELECT SYSTIMESTAMP FROM DUAL;

After running the SQL query above, the current system timestamp will be returned. You can compare, compute, or display the results with other query results as needed.