Oracle TimeStamp to Char conversion - SQL Snipplr Social Repository

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