I have a table whose date fields are all declared as NUMBER. For example, the value 14076 is supposed to represent 16-Jul-2008. I'm not sure how this number was created - whether it was internally created by the system or it was converted using TO_DATE / TO_NUMBER functions. I'd like to convert this number to a date (i.e. from 14076 to 16-Jul-2008). Could you please help ?
The Oracle version I'm using is 188.8.131.52.
Your assistance is greatly appreciated.