Conversion of number data type to date

[O.T.Y.]

Hi, i ve a problem trying to convert a number data type to a readable date format.
Description of prob :
number values ( eg : 1093226647962L )retrieve from a query from Oracle database
convert to date format ( DD-MM-YYYY HH24:MI:SS)

please help.....

 

[BWendling]

Which start date refers this number to?
-4712-01-01, the Oracle beginning of time?

With a reasonable number (e.g. 2453501, but not 1093226647962) you could do:
select to_char(to_Date('-4712-01-01','SYYYY-MM-DD')+2453501.234,'SYYYY-MM-DD HH24:MI:SS')
from dual