Advanced Search

Return to Snippet

Revision: 71264
at February 2, 2017 05:31 by bbrumm
Initial Code 
--SYSTIMESTAMP

--Example 1
SELECT SYSTIMESTAMP
FROM dual;

--Example 2
SELECT SYSDATE, SYSTIMESTAMP
FROM dual;

--Example 3
SELECT SYSTIMESTAMP, TO_CHAR(SYSTIMESTAMP, 'dd Mon yyyy') AS text_output
FROM dual;
Initial URL 
http://www.databasestar.com/oracle-systimestamp-function/
Initial Description 
A few examples of the SYSTIMESTAMP function.
Initial Title 
Oracle SYSTIMESTAMP Function
Initial Tags 
sql, Oracle
Initial Language 
SQL