• Oracle Timestamp Data Type
  Oracle timestamps explained. Includes SYSTIMESTAMP, LOCALTIMESTAMP, CURRENT_TIMESTAMP, SESSIONTIMEZONE, DBTIMEZONE and examples.
  in Oracle > DB 11g with current_timestamp dbtimezone localtimestamp oracle sessiontimezone systimestamp timestamps
• Convert Oracle Timestamp to STRING - Oracle Forums
  SELECT TO_CHAR (SYSTIMESTAMP, 'YYYY-MON-DD HH24:MI:SS') AS my_date FROM DUAL
  in Oracle > DB 11g with my_date systimestamp to_char

systimestamp from all users