RE: Convert Long to Date

From: Brady, Mark <Mark.Brady_at_Constellation.Com>
Date: Thu, 26 Jun 2008 15:52:38 -0400
Message-ID: <72AB68B424526641A8514835270C2EB502D0D079@EXM-OMF-21.Ceg.Corp.Net>


OK... so then I find this.  

http://asktom.oracle.com/pls/asktom/f?p=100:11:3252719468565533::::P11_Q UESTION_ID:839298816582   Is this really the best solution 3 years later?  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Brady, Mark Sent: Thursday, June 26, 2008 3:11 PM
To: oracle-l-freelists
Subject: Convert Long to Date  

Oracle stores the High Value of a Partition in a Long column. I swear I've searched the friendly web, and I just can't figure out how to get this long column converted back to a date or char I can take a char to a date.

If it exists on the web, please tell me. I don't know why this is so hard to find.

>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the
addressee. If you are not the intended recipient, do not use the information
in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 26 2008 - 14:52:38 CDT

Original text of this message