Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting FLOAT to Date

444553May 25 2005 — edited May 26 2005
We have an application that stores dates as FLOATs in its Oracle tables. For example, since I'm writing this at 3:40 CDT on 05/25/2005, the FLOAT representation of this is 38497.6531944444. Via SQL, how can I convert this to a date that my eyeballs can understand? Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 23 2005
Added on May 25 2005
3 comments
1,874 views