Advanced Search

Return to Snippet

Revision: 71601
at March 3, 2017 15:14 by bbrumm
Initial Code 
--LOCALTIMESTAMP

--Example 1
SELECT LOCALTIMESTAMP
FROM dual;

--Example 2
ALTER SESSION SET TIME_ZONE = '+4:0';

SELECT LOCALTIMESTAMP
FROM dual;


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