Posted By

bbrumm on 03/13/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 03/13/17 05:12am

Statistics

Viewed 3449 times

Favorited by 0 user(s)

Related snippets

Oracle NEW_TIME Function

/ Published in: SQL

A few examples of the NEW_TIME function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--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';