Posted By

mprabhuram on 07/02/10

Tagged

Viewed 927 times

Favorited by 0 user(s)

/ Published in: SQL

use this to convert the oracle time stamp into a character.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT TO_CHAR(CURRENT_TIMESTAMP,'YYYYMMDDHH24MISSFF') FROM dual;
 
 
RESULT:
------
20100701162937883230

Comment:

You need to login to post a comment.