Advanced Search

Return to Snippet

Revision: 28149
at July 2, 2010 06:35 by mprabhuram
Initial Code 
SELECT TO_CHAR(CURRENT_TIMESTAMP,'YYYYMMDDHH24MISSFF') from dual;


Result:
------
20100701162937883230
Initial URL 
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions180.htm
Initial Description 
use this to convert the oracle time stamp into a character.
Initial Title 
Oracle TimeStamp to Char conversion
Initial Tags 
sql, Oracle
Initial Language 
SQL