There are two columns named 'WriteTime', 'Timestamp' in my oracle DB and the values are like '1210528051025060', '1210528050500000'. The format of WriteTime and Timestamp are char(16). I want to convert it to date format. How do I do that? Does anybody have any idea?
Tried To_Date() function but it didn't work at all.
Please Help
