The Oracle CURRENT_TIMESTAMP function will give you the current time with all details. It returns the current timestamp with time zone for the current session's time zone. This is similar to the Oracle SYSTIMESTAMP function, but the precision to which the TIMESTAMP is returned can be specified. (If no precision is specified, the default is 6.)
SELECT CURRENT_TIMESTAMP FROM DUAL;
You may also want to see the entries for SYSTIMESTAMP and LOCALTIMESTAMP, plus the Timestamp Data Type Demos.
Related Code Snippets:
- Current_timestamp - The current_timestamp function returns the current date and time in the time z...