http://netvouz.com/MondoTofu/tag/to_char?feed=rss MondoTofu's bookmarks tagged "to_char" on Netvouz http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements004.htm#SQLRF00210 Oracle TO_DATE, TO_NUMBER, TO_CHAR with formats and examples Oracle > DB 11g MondoTofu Wed, 19 Mar 2014 17:14:50 GMT http://www.club-oracle.com/forums/convert-oracle-timestamp-to-date-t692/ SELECT TO_CHAR (SYSTIMESTAMP, 'YYYY-MON-DD HH24:MI:SS') AS my_date FROM DUAL Oracle > DB 11g MondoTofu Mon, 25 Mar 2013 20:26:17 GMT