Converting long value column into date using sql query itself. Oracle, 9i
Posted on 2008-11-05
In oracle db I have a column with integer data type, the actual content is milliseconds of date. I required a sql query which converts those milliseconds value into date value. For example, the value in the column is 1225825655, and required value should be in the form of 'mm/dd/yyyy'. I going to use this query in the iReport, so the modification is required in the query itself.