Posted By

bbrumm on 03/13/17


Tagged

sql Oracle


Versions (?)

Oracle NEW_TIME Function


 / Published in: SQL
 

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

A few examples of the NEW_TIME function.

  1. --NEW_TIME
  2.  
  3. --Example 1
  4. SELECT SYSDATE,
  5. NEW_TIME(SYSDATE, 'GMT', 'PST') AS newtime_test
  6. FROM dual;
  7.  
  8.  
  9.  
  10. SELECT SYSTIMESTAMP,
  11. NEW_TIME(SYSTIMESTAMP, 'GMT', 'PST') AS newtime_test
  12. FROM dual;
  13.  
  14.  
  15. SELECT SYSTIMESTAMP,
  16. TO_CHAR(NEW_TIME(SYSTIMESTAMP, 'GMT', 'PST'), 'dd-mm-yy hh:mi:ss AM') AS newtime_test
  17. FROM dual;
  18.  
  19.  
  20.  
  21. SELECT value
  22. FROM nls_database_parameters
  23. WHERE parameter = 'NLS_CHARACTERSET';

Report this snippet  

You need to login to post a comment.