• 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

my_date from all users