Oracle NEW_TIME Function - SQL Snipplr Social Repository

Revision: 71800

at March 13, 2017 05:12 by bbrumm

Initial Code

--NEW_TIME

--Example 1
SELECT SYSDATE,
NEW_TIME(SYSDATE, 'GMT', 'PST') AS newtime_test
FROM dual;



SELECT SYSTIMESTAMP,
NEW_TIME(SYSTIMESTAMP, 'GMT', 'PST') AS newtime_test
FROM dual;


SELECT SYSTIMESTAMP,
TO_CHAR(NEW_TIME(SYSTIMESTAMP, 'GMT', 'PST'), 'dd-mm-yy hh:mi:ss AM') AS newtime_test
FROM dual;



SELECT value 
FROM nls_database_parameters
WHERE parameter = 'NLS_CHARACTERSET';

Initial URL

http://www.databasestar.com/oracle-new_time

Initial Description

A few examples of the NEW_TIME function.

Initial Title

Oracle NEW_TIME Function

Initial Tags

sql, Oracle

Initial Language

SQL

Choose a language for easy browsing: