Filename - varchar
Creation Date - Date format dd/mm/yyyy hh24:mi:ss
Oldest cdr date - Date format dd/mm/yyyy hh24:mi:ss
Arithmetic operations between dates in Oracle return their results in days, so if you want to get the difference in hours, you would multiply the results by 24. If you want it in minutes, you would multiply it by 24*60, and so on.
You could also use the TO_TIMESTAMP function to convert both dates to timestamps. That way when you substract them, you would get your results in the format: DD HH:MI:SS.MS.
Register Hereor login if you are already a member