http://netvouz.com/MondoTofu/tag/my_date?feed=rss MondoTofu's bookmarks tagged "my_date" on Netvouz 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