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 126.96.36.199.
Your assistance is greatly appreciated.
It works. If you don't mind, could you please explain the logic of your SQL statement ?
1) Why Jan 1, 1970 particularly ?
2) And how was this N number calculated in the first place i.e. from 16 Jul 08 to 14076 ?
Thank you for your help.