asked on
Convert number to date in Oracle
Hello,
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 9.2.0.8.
Your assistance is greatly appreciated.
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 9.2.0.8.
Your assistance is greatly appreciated.
Oracle Database
Last Comment
Sean Stuber
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.