RE: Convert Long to Date

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 26 Jun 2008 16:11:36 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902856F8E@usahm208.amer.corp.eds.com>

Use PL/SQL. Read the long into a varchar2 and then perform a to_date on the varchar2 variable into a date variable. You can put this into a user function if desired.  

• Mark D Powell -- Phone (313) 592-5148

  ---

        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 - 15:11:36 CDT