Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Get the SYSTIMESTAMP

SQL> --SYSTIMESTAMP() SQL> SQL> SELECT SYSTIMESTAMP FROM dual; SYSTIMESTAMP --------------------------------------------------------------------------- 16-SEP-06 05.35.06.531000 PM -07:00 SQL>