Netvouz / MondoTofu / tag / systimestamp http://netvouz.com/MondoTofu/tag/systimestamp?feed=rss MondoTofu's bookmarks tagged "systimestamp" on Netvouz Oracle Timestamp Data Type http://psoug.org/reference/timestamp.html Oracle timestamps explained. Includes SYSTIMESTAMP, LOCALTIMESTAMP, CURRENT_TIMESTAMP, SESSIONTIMEZONE, DBTIMEZONE and examples. Oracle > DB 11g MondoTofu Thu, 07 Mar 2013 19:55:19 GMT Convert Oracle Timestamp to STRING - Oracle Forums 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