• Format Models
  Oracle TO_DATE, TO_NUMBER, TO_CHAR with formats and examples
  in Oracle > DB 11g with date format models oracle time to_char to_date to_number
• 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

to_char from all users