Advanced Search

Return to Snippet

Revision: 71295
at February 13, 2017 12:47 by bbrumm
Initial Code 
SELECT CURRENT_TIMESTAMP,
SYS_EXTRACT_UTC(CURRENT_TIMESTAMP)
FROM dual;


SELECT CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP - INTERVAL '4' HOUR
FROM dual;

SELECT CURRENT_TIMESTAMP
FROM dual;

SELECT CURRENT_TIMESTAMP(2)
FROM dual;
Initial URL 
http://www.databasestar.com/oracle-current_timestamp/
Initial Description 
A few examples of the CURRENT_TIMESTAMP function.
Initial Title 
Oracle CURRENT_TIMESTAMP Function
Initial Tags 
sql, Oracle
Initial Language 
SQL