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